a sql query from oracle database

Question

I have two columns(column1, column2) in my oracle database table named as demo. I want to select same column1 having different column2.

SQL> select * from demo;

column1 | column2
--------|--------
A       | 10           
A       | 20
A       | 30
A       | 30

I want the following output with count(*):

column1 | column2
--------|--------
A       | 10           
A       | 20

How can i do this? Any help is much appreciated

You mean if a value in column1 has different values in column2 right? Then I presume the third row in your select * should be something other than A? — jb10210
– jb10210, Commented Apr 3, 2012 at 11:07
You can do this using the COUNT operator and the GROUP BY and HAVING constructs — Chetter Hummin
– Chetter Hummin, Commented Apr 3, 2012 at 11:11
@jb10210 you are close to right but other than A means? I have that above pattern of records in my database — saroj
– saroj, Commented Apr 3, 2012 at 11:14
@AmitBhargava can you please little bit clarify? what should be my right query? i have written almost many sorts of sql queries but no result — saroj
– saroj, Commented Apr 3, 2012 at 11:15

score 2 · Accepted Answer · 2012-04-03 11:29:16Z

2

Try:

select column1, column2
from myTable 
group by column1, column2
having count(*) = 1

answered Apr 3, 2012 at 11:14

user359040

Sign up to request clarification or add additional context in comments.

1 Comment

Why would this query lead to the desired output?