using union select * from tableA union select * from tableB

How would you retrieve Unique rows from table without using UNIQUE and DISTINCT keyword?

Question Posted / jayanth

Answer Posted / jayanth

using union
select * from tableA
union
select * from tableB

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Does order by actually change the order of the data in the tables or does it just change the output?

1128

How do you implement session management in SQL Server mode?

1084

What do you understand by coalesce in sql server?

1057

Can we use where clause in union?

1055

What is best institute to Learn DotNET And SQL in chennai?

2156

Do you know what guidelines should be followed to help minimize deadlocks?

964

How each E-R model constructs can be mapped to the relational model?

989

Will sql server 2005 allow you to reduce the size of a column?

976

Can a database be shrunk to 0 bytes, if not, why?

1087

Explain system functions or built-in functions? What are different types of system functions?

961

What is check constraint in sql server?

989

What is an identity?

996

What is the difference between functions and stored procedures?

1149

What is read uncmmited?

1049

What is difference between rownum and row_number?

954