select distinct * from emp;

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

Question Posted / rakesh

Answer Posted / rakesh

Is This Answer Correct ?

2 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is not in sql?

941

Do ddl statements need commit?

961

What are data types in pl sql?

1137

What is the difference between local variables and global variables?

1121

Can we insert data into materialized view?

940

how to calculate the difference between two dates? : Sql dba

1057

Is not equal in sql?

1010

What is program debugging?

1240

What are all the different normalization?

1037

What are the differences between in and exists clause?

1109

what are string data types? : Sql dba

1039

define sql insert statement ? : Sql dba

1019

How do I find sql profiler?

933

What is sql and its types?

1174

What is sql catalog?

1014