Which two of the following query will produce same result

Jeevanand · New User Joined: 26 Dec 2006 Posts: 4 Location: Coimbatore

Consider that student table having

stud no
1
2
3
3

Which two of the following query will produce same result

1--- select * from stud
union
select * from stud

2----select Distinct from stud

3----select * from stud

4----select * from stud
union all
select * from stud

Prajesh_v_p · Active User Joined: 24 May 2006 Posts: 133 Location: India

I think 1 and 2.. as union removes duplicates..

priyamnavada · New User Joined: 24 Dec 2005 Posts: 52 Location: hyderabad

Query 1 and 2 gives the same result