How would you retrieve Unique rows from table without using UNIQUE and DISTINCT keyword?
- 2 Answers
- 1959 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 there a column to which a default can't be bound? : Sql server database administration
Explain the different types of joins?
What is the purpose of forms?
What is the security principal at the server level that represents your session?
What is the difference between ROW_NUMBER and Ranking function in SQL SERVER?
How to configure odbc dsn with different port numbers?
What happens if null values are involved in datetime operations?
Is the order of columns in the set clause important in ms sql server?
What is thr feature of change data capture?
When would you use sql joins?
What do you understand by a stored procedure?
What is fill factor and pad index?
what is raid and what are different types of raid configurations? : Sql server database administration
List the ways in which dynamic sql can be executed?
What is multi-statement table-value user-defined function?
