Viewing 4 posts - 1 through 4 (of 4 total)
sorry syntax is missed.
with numbered as(SELECT rowno=row_number()
over (partition by rand() order by rand())from Tablename)
Delete from numbered where rowno= (select max(rowno) from numbered)
June 23, 2008 at 3:42 am
with numbered as(SELECT rowno=row_number()
over (partition by rand() order by rand())from )
select * from numbered where rowno= (select max(rowno) from numbered)
June 23, 2008 at 3:39 am
Hi,
use this Query...
with numbered as(SELECT rowno=row_number()
over (partition by rand() order by rand())from )
Delete from numbered where rowno= (select max(rowno) from numbered)
June 23, 2008 at 3:38 am
Viewing 4 posts - 1 through 4 (of 4 total)