var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: selecting unique rows
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
try something like,
select count(*), col1, col2, col3 etc.,,
group by 2,3,4 etc...
order by 1 desc
hi it seems it is not working it is giving a syntax errors
Last edited by ahmedwaseem2000; 01-24-05 at 13:02.
Try this -
select count(*), no, name
group by 2,3
you can subsitute the = clause with > & <
select col1, col2, col3 etc.,,
group by 1,2,3 etc...