KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I have a table similar to: domain | file | Number ------------------------------------ aaa.com | aaa.com_1 | 111 bbb.com | bbb.com_1 | 222 ccc.com | ccc.com_2 | 111 ddd.com | ddd.com_1 | 222 eee.com | eee.com_1 | 333 I need to query the number of Domains that share the same Number and their File name ends with _1 . I tried the following: select count(domain) as 'sum domains', file from table group by Number having count(Number) >1 and File like '%\_1'; It gives me: sum domains | file ------------------------------ 2 | aaa.com 2 | bbb.com I expected to see the following: sum domains | file ------------------------------ 1 | aaa.com 2 | bbb.com Because the Number 111 appears once with File ends with _1 and _2 , so it should count 1 only. How can I apply the 2 conditions that I stated earlier correctly ?
Tags (comma-separated)
Save Edits
Cancel