Delete duplicate rows without using rowid.





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

Post New Answer



More SQL Server Interview Questions

What is the diff between Dynamic queries and static queries

1 Answers   ICS Integrated Computer Solutions, CGG,


How do use Having,Group by,Group function in SQL?

0 Answers  


How to determine the service pack currently installed on SQL Server?

4 Answers   HCL,


What are sub-queries? Give example? In which case sub-queries are not feasible?

4 Answers   Infosys,


What is indexing?

0 Answers   AOL,






Display a roll having miminum marks in two subjects?

7 Answers   Patni,


why SQL server is more used to store database rather than Access

2 Answers  


How to give a user the option of importing Excel and a delimited text file into a SQL Server Database without manually using SQL DTS?

1 Answers   GE,


Can you have a nested transaction?

4 Answers   HCL,


Using query analyzer, name 3 ways you can get an accurate count of the number of records in a table?

5 Answers   eFunds,


What's the difference between a primary key and a unique key?

4 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  





Categories