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 sql in oracle?

1057

What is difference between hql and sql?

1070

Explain the difference between rename and alias?

1010

How do you update f as m and m as f from the below table testtable?

1849

How many columns should be in an index?

959

How is a process of pl/sql compiled?

1150

Which kind of parameters cannot have a default value in pl sql?

1140

Is sql workbench free?

987

What are the commands used in sql?

1070

What are the methods of filing?

933

Does sql view stored data?

949

How to read/write files from pl/sql?

1035

Can we call stored procedure in function?

955

Explain the commit statement.

1151

what is normalization? : Sql dba

1080