How would you retrieve Unique rows from table without using UNIQUE and DISTINCT keyword?
- 2 Answers
- 2548 Views
- Genpact, I also Faced
- E-Mail Answers
Answer Posted / jayanth
using union
select * from tableA
union
select * from tableB
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Is null in sql server?
What are locks in sql?
How do I start and stop sql server?
List all types of constraints in sql server?
Explain database normalization?
What is the sql server agent?
You want your report to display a hyperlink that will take users to your intranet. How do you configure such a hyperlink?
What is the command used to recompile the stored procedure at run time?
Explain what is dbcc?
What command is used to create a database in the sql server and how?
how many clustered indexes can be created on a table? : Sql server database administration
you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration
What is nonclustered index on computed columns?
What are the different types of columns types constraints in the sql server?
Call by value and call by reference in procedure and function, with NOCOPY.
