it will fetch all the salaries one tme in case of duplicacy

select sal from emp group by sal

Question Posted / pankajsharma

Answer Posted / pankajsharma

Is This Answer Correct ?

3 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What are the parts of a basic sql query?

916

What are the key differences between SQL and PL SQL?

1146

What is sql catalog?

961

what is a stored procedure? : Sql dba

1051

Why truncate is used in sql?

935

What is offset and limit in sql?

998

How do I view a table in sql?

943

Why do we use procedures in pl sql?

959

How to take user input in pl sql?

1105

Can sql developer connect to db2?

981

Explain the significance of the & and && operators in pl sql.

949

what tools available for managing mysql server? : Sql dba

1005

What is percent sign in sql?

1212

discuss about myisam index statistics collection. : Sql dba

905

what is sql server agent? : Sql dba

1027