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

Explain ttitle and btitle.

1116

Why use truncate instead of delete?

1010

When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?

1109

Is a table valued function object?

1007

how to do backup entire database? : Transact sql

1136

How do you explain an index number?

1095

what is a unique key ? : Sql dba

1087

What is a nested table in word?

952

explain the options of myisamchk to improve the performance of a table. : Sql dba

1003

What schema means?

884

Differentiate between pl/sql and sql?

1144

How delete all records from table in sql?

977

What is date functions?

1024

Does normalization improve performance?

1031

What are the three forms of normalization?

1040