Snippets.PRO

Keep, track and share your code snippets with your friends

24.09.2013 05:24 stalin SQL 0 Comments

Select Duplicates ... Reveal Code

select field1,field2,field3, count(*)
  from table_name
  group by field1,field2,field3
  having count(*) > 1

984

22.09.2013 04:23 stalin SQL 0 Comments

Delete N rows from table ... Reveal Code

DELETE FROM [tbCode] WHERE [CodeID] IN (SELECT TOP N [CodeID] FROM [tbCode] order by [CodeID] desc)

855