selecting unique rows

ahmedwaseem2000 · #1 (**permalink**) 01-24-05, 11:04

Hi, there are around 10 columns which has got duplicate rows so could any one of you please help me retriving unique rows. rows that are unique for all the 10 columns.

Thanks in advance

Cheers,
Waseem

artemka · #2 (**permalink**) 01-24-05, 11:41

try something like,
select count(*), col1, col2, col3 etc.,,
from tabname
group by 2,3,4 etc...
order by 1 desc

ahmedwaseem2000 · #3 (**permalink**) 01-24-05, 11:50

hi it seems it is not working it is giving a syntax errors

lloydnwo · #4 (**permalink**) 01-24-05, 23:14

Try this -

select count(*), no, name
from test
group by 2,3
having count(*)=1

you can subsitute the = clause with > & <

alinxiong · #5 (**permalink**) 01-25-05, 04:25

select col1, col2, col3 etc.,,
from tabname
group by 1,2,3 etc...

Internet Services

Web Development

Digital Marketing

Consumer Tech