Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.


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

Post New Answer

More SQL Server Interview Questions

what is advantages in sql 2005 over sql 2000?

4 Answers  


what is the difference between Delete and Truncate

4 Answers   CarrizalSoft Technologies, Geo Research Centre,


What are the different types of replication are there in sql server 2000?

0 Answers  


What is buffer cash and log cache in sql server?

0 Answers  


How To Make password Protected SQL Server 2005 Database i.e when i open SQL Server database then ask for password.

1 Answers  






What is query and its types?

0 Answers  


What is key attribute?

0 Answers  


What is the advantage of specifying WITH GRANT OPTION in the GRANT command?

2 Answers  


how to rename the table

3 Answers  


Which are the third-party tools used in sql server and why would you use them?

0 Answers  


What do you understand by recursive stored procedure?

0 Answers  


create table with fields ID, reserved_by,res_date res_date is datefield like 2010-03-09 00:00:00.000 from 2005 to 2006 any date assume based on res_date need to slect table and display based on month (full jan details in database irrespective of date and year

3 Answers  


Categories