How would you retrieve Unique rows from table without using UNIQUE and DISTINCT keyword?
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
What is the advantage of sql server?
When would you use the stored procedures or functions?
What is a heap?
What is difference between equi join and natural join?
How to create a simple table to test triggers in ms sql server?
Do you know how to send email from database?
What is named query? : sql server analysis services, ssas
What is the downside of using udf?
What is the default schema of your login session in ms sql server?
Explain logical operators in sql server?
Explain differences between web edition and business edition?
What are the differences between INNER JOIN, LEFT JOIN and RIGHT JOIN in SQL Server?
Explain the truncate command? : SQL Server Architecture
How to create a local temporary stored procedure?
how can you attach more than 20 ldf files in sql server