select distinct(emp_name) from employees;

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

Question Posted / suma

Answer Posted / suma

Is This Answer Correct ?

27 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Which is faster joins or subqueries?

931

what are the different functions in sorting an array? : Sql dba

969

What is record in pl sql?

1011

Can a commit statement be executed as part of a trigger?

998

how do you control the max size of a heap table? : Sql dba

924

is mysql query is case sensitive? : Sql dba

1031

Is left join faster than inner join?

1065

What is a recursive join sql?

1027

Explain what is sql?

1061

What is difference between left and right outer join?

933

What is procedure and function in sql?

930

Why do we use triggers?

916

Does pl/sql support create command?

1045

What is the difference between local variables and global variables?

1071

Is record in oracle pl sql?

904