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 are expressions?

757

Does view contain data?

788

What is recursive join in sql?

752

What is the left table in sql?

699

Describe types of sql statements?

722

How many disk partitions should I have?

719

what is a trigger? : Sql dba

762

What is sql stand for?

744

What is full join?

699

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

1068

what are string data types? : Sql dba

701

What is difference between table and view?

706

How do I count rows in sql query?

690

What is error ora-01000: maximum open cursors exceeded

783

What is the purpose of a secondary key?

681