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

What is sql partition?

1101

What are operators available in sql?

1037

Where do we use pl sql?

991

What is rownum and rowid?

1027

What does bitemporal mean?

1059

Is a foreign key always unique?

935

Can we perform dml in function?

1061

Show how functions and procedures are called in a pl/sql block.

1116

What is index example?

1000

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

1009

Which table is left in join?

972

what is the use of set statement in tsql? : Transact sql

1001

How to revise and re-run the last sql command?

1159

What is a pdo connection?

1023

What is Materialized View? In What Scenario we Use Materialized View?

9503