How would you retrieve Unique rows from table without using UNIQUE and DISTINCT keyword?
- 2 Answers
- 2027 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
Are null values the same as that of zero or a blank space?
What is difference between drop truncate and delete?
How to delete multiple rows with one delete statement in ms sql server?
How can we remove orphan records from a table?
What is meant by dirty read?
What are locks in sql?
What is model database in sql server?
Define indexes?
How to drop an existing stored procedure in ms sql server?
Difference between Inner vs outer joins?
What are filegroups in sql server?
What are trace flags and mention a few common trace flags used with sql server?
Tell me about normalization in DBMS.
How to set a database state to offline in ms sql server?
How to add an address record into adventureworkslt?
