correct select distinct(emp_name) from employees;

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

Question Posted / klkl

Answer Posted / klkl

correct
select distinct(emp_name) from employees;

Is This Answer Correct ?

3 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How can you view the errors encountered in a trigger?

915

what is the difference between nested subquery and correlated subquery?

983

What is consistency?

1060

What are the types of queries in sql?

1013

What is the difference between a subquery and a join?

1010

what is a field in a database ? : Sql dba

987

What is the primary use of normalization?

939

What plvcmt and plvrb does in pl/sql?

1249

What are synonyms in sql?

928

What is materialized view in sql?

870

How do you create a db file?

956

What is fmtonly in sql?

1004

How does cross join work?

874

what is clause? : Sql dba

1001

Why is pl sql used?

935