retrieving the record which has only one value
- by ashwani66476
Hello All,
Please suggest me a query, which retrieves only those record which has the single row in table. For Example
table1.
name age
aaa 20
bbb 10
ccc 20
ddd 30
If I run "select distinct age from table1. result will be
age
20
10
30
But I need a query, which give the result like
name age
bbb 10
ddd 30
Thanks....