select distinct * from emp; OR select unique * from emp;

How will you select unique values from a list of records?

Question Posted / os reddy

Answer Posted / os reddy

select distinct * from emp;

OR

select unique * from emp;

Is This Answer Correct ?

6 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is scalar function in sql?

1040

How do I count records in sql?

1008

Can we create table in function?

965

how to return query output in html format? : Sql dba

1073

Does access use sql?

1045

Is delete faster than truncate?

1002

Can a table contain multiple primary key’s?

1098

What is sql*loader and what is it used for?

1153

What is the difference between Union and Union all. Which is faster.

1403

How to write a query to show the details of a student from students table whose

1000

what are the limitations of identity column? : Transact sql

1108

how can we submit a form without a submit button? : Sql dba

988

what happens if you no create privilege in a database? : Sql dba

1001

How to install oracle sql developer?

1046

what are different types of collation sensitivity? : Sql dba

1067