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 is a result set object returned by odbc_exec()?

0 Answers  

What is the main difference between ‘between’ and ‘in’ condition operators?

0 Answers  

hi ..i am working as a sql dba.....now i want to learn more about t-sql..... is it possible to learn online.... plz refer any site ..thankq

0 Answers   IBM,

What is the Disadvantage of indexed sequential file.

0 Answers   HCL,

Explain how to maintain a fill factor in existing indexes?

0 Answers  




Define self join?

0 Answers  

What is the stuff and how does it differ from the replace function?

0 Answers  

How to retrieve error messages using odbc_errormsg()?

0 Answers  

What is SCOPE_IDENTITY() in sql

4 Answers   Cap Gemini,

What is sql or structured query language?

0 Answers  

What are the difference between data mart and data warehouse? : sql server analysis services, ssas

0 Answers  

What is a functions and types in sql server?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories