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

Explain the difference between 'between' & 'and' operators in sql

1046

What is difference between primary and secondary key?

1073

How do I send sql query results to excel?

1113

what is text? : Sql dba

1120

How to Declare Fixed Length String Value In PL SQL

1207

Is it possible to include an insert statement on the same table to which the trigger is assigned?

1063

Explain the rollback statement?

1072

What is 19 null in sql?

1020

How to Execute a Package in PL/SQL.?

1286

how to delete an existing column in a table? : Sql dba

1062

How do you go back in sql?

1029

Can we use loop in sql?

1010

What is the use of sql trace?

1003

Why coalesce is used in sql?

1067

Why left join is used in sql?

1019