1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

How would you retrieve Unique rows from table without using UNIQUE and DISTINCT keyword?

Question Posted / aman parihar

Answers were Sorted based on User's Feedback



How would you retrieve Unique rows from table without using UNIQUE and DISTINCT keyword?..

Answer / jayanth

using union
select * from tableA
union
select * from tableB

Is This Answer Correct ?    0 Yes 0 No

How would you retrieve Unique rows from table without using UNIQUE and DISTINCT keyword?..

Answer / virendra maurya

We can simply remove duplicate from table
1. Using CTE
2. Using Group by
3. Using Rank function

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More SQL Server Interview Questions

What are the differences between decimal and float in ms sql server?

0 Answers  

What is enhanced database mirroring in sql server 2008?

0 Answers  

Which command is used for user defined error messages?

0 Answers  

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?

0 Answers  

How can sql injection be stopped? : sql server security

0 Answers  




What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?

0 Answers  

What is an execution plan? When would you use it? How would you view the execution plan?

1 Answers  

write coding for importing sql data into a word excel...

1 Answers   Oracle,

what is a join? : Sql server database administration

0 Answers  

What are the advantages of partitioning?

0 Answers  

What is the difference between NOROW and LOCKROW?

0 Answers   Accenture, Honeywell, Satyam,

plss anybody specify tha constrian management system in dbms

0 Answers   Police Constable,

For more SQL Server Interview Questions Click Here
Categories