Run Code  | Code Wall  | Users  | Misc  | Feedback  | About  | Login  | Theme  | Privacy 

exclude some rows from counts without row_number

Language: Editor: Layout:
View schema
Execution time: 0,02 sec, rows selected: 3, rows affected: 11, absolute service time: 0,22 sec, absolute service time: 0,21 sec 
edit mode |  history
   cityid districtid distinctfamiliynames totalnamesperdistrict
1 Austin 1 3 3
2 Austin 2 2 3
3 Austin 3 1 5