Write an sql query for deleting duplicate rows?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

What is data compression? : sql server database administration

0 Answers  


How do you send email on SQL Server?

0 Answers   MindCracker,


What is nested transaction?

0 Answers  


What are functions

3 Answers  


What are the requirements to use odbc connections in php scripts?

0 Answers  






system date format is "yy-mm-dd" "select getdate()" ----> 2009-01-24 20:03:28.513 if i write "select dateadd(dd,2,getdate()) ".it returns "2009-01-26 19:59:38.340"...my question is dat could it be possible to retrive da date in da format "26 jan 2009 ...."??

8 Answers  


What are “lock” hints?

0 Answers  


can any body tell me how to know the password of current user in sql server

0 Answers   Crea, HCL,


What are the differences between INNER JOIN, LEFT JOIN and RIGHT JOIN in SQL Server?

0 Answers   QuestPond,


How to view existing indexes on an given table using sp_help?

0 Answers  


What is excution Plan in sql server

1 Answers   CarrizalSoft Technologies, TCS,


Why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it?

0 Answers  


Categories