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
Is sql server free?
Where can you add custom error messages to sql server?
What are the different Topologies in which Replication can be configured?
How efficient you are in oracle and SQL server?
While migrating Microsoft SQL Server 2008 database to SQL Azure, what can be done to ensure the database connectivity does not degrade?
Which event (check constraints, foreign key, rule, trigger, primary key check) will be performed last for an integrity check?
What is xml datatype?
How to filter out duplications in the returning rows in ms sql server?
What is an expensive query?
What are the differences between DDL, DML and DCL in SQL?
Explain about the command-line tool SQLCMD?
Explain powershell included in sql server 2008?
List down some advantages of sql stored procedure?
Explain the different types of joins?
What is a transaction and why is it important?