select sal from emp group by sal; and select distinct sal from emp ; Both

select sal from emp group by sal

Question Posted / arun karthick

3 Answers
6358 Views
TCS, I also Faced
E-Mail Answers

Answer Posted / arun karthick

select sal from emp group by sal; and select distinct sal
from emp ;
Both queries will give the same result - fetch the salary
in emp table without duplicates.

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Can we insert data in view?

951

What is primary key secondary key alternate key candidate key?

1024

What is the difference between microsoft access and sql?

1006

How many postgresql users are there, worldwide?

1047

What is sql and db2?

981

how to select unique records from a table? : Sql dba

1092

What are basic techniques of indexing?

1367

What is the difference between an inner and outer join?

1004

What are the basic techniques of indexing?

1052

Is primary key clustered index?

940

what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba

1040

Is pl sql different from sql?

974

What is the default isolation level in sql server? : Transact sql

1012

Does postgresql run on the cloud?

1129

What is a temporal table?

920