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

Can we use ddl commands in pl sql?

1069

What is data modelling in sql?

961

How long will it take to learn pl sql?

889

Mention what does the hierarchical profiler does?

1020

Is id a reserved word in sql?

1090

Why is a trigger used?

887

What are triggers in sql?

971

What is sqlerrd?

921

Which is better stored procedure or query?

918

how is exception handling handled in mysql? : Sql dba

1007

How can we connect an Android App to an Oracle database and use the PL/SQL procedural code?

1072

How to raise user-defined exception with custom sqlerrm ?

1061

How does an execution block start and end in pl sql?

900

How does stored procedure reduce network traffic?

965

what is query cache in mysql? : Sql dba

991