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

Can you use order by when defining a view?

0 Answers  

How will you know when statistics on a table are obsolete?

0 Answers  

Why do we use non clustered index?

0 Answers  

Can you index views?

0 Answers  

How many types of dimensions are there and what are they? : sql server analysis services, ssas

0 Answers  




why cluster and non clusterindex are used in sqlserver 2000? explain with example

1 Answers  

between cast and convert which function would you prefer and why?

0 Answers  

What is the latest version of microsoft sql server?

0 Answers  

To automatically record the time on which the data was modified in a table, which data type should you choose for the column?

0 Answers  

Can we install sql server 2016 on windows 7?

0 Answers  

How you can get a list of all the table constraints in a database?

0 Answers  

Explain the first normal form(1nf)?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories