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

How to get unique records from a table?

897

What is record in pl sql?

1009

What do you understand by pl/sql records?

960

What is schema in sql?

886

Why do we use function in pl sql?

1007

Why is theta join required?

1080

How do I truncate a word?

997

what are myisam tables? : Sql dba

951

What is difference between group by and partition by?

977

what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba

994

What are the various levels of constraints?

1059

what is innodb? : Sql dba

1033

Why having clause is used in sql?

926

What is a data definition language?

1027

what is query cache in mysql? : Sql dba

991