Write a code to select distinct records without using the DISTINCT keyword.


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

Post New Answer

More SQL Server Interview Questions

How do I find my localdb version?

0 Answers  


How do I view a script in sql server?

0 Answers  


What are cursors? Explain the different types of cursors Enlist a few disadvantages of cursors.

0 Answers   Genpact,


what is the order of execution of where,having,group by in select stement

6 Answers   IBM, Tanla Solutions,


What is the disadvantage of using subquery exact after a select statement?ex. select (select * from sometable)

1 Answers  






How can you see what type of locks used?

1 Answers  


What is the difference between DATETIME2 and DATETIME?

0 Answers   Infosys,


What is a transaction and what are ACID properties?

14 Answers   Config Systems, IBM, TCS, Virtusa,


How do you find value of first column before inserting value into the second column in the same table for checking that second column must have different value than first column.

2 Answers   L&T,


What are Row versions of DataRow?

0 Answers  


Please illustrate physical database architecture? : SQL Server Architecture

0 Answers  


where the connection string store in the database

0 Answers   HCL, Wipro,


Categories