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 the commit statement.

1159

What is a delimiter in sas?

1058

What is trigger price?

989

Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql

990

How do I restart sql?

975

How much does sql certification cost?

1094

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

1117

What is the command used to fetch first 5 characters of the string?

1401

Does truncate remove indexes?

1034

How does sql store data?

921

What is rename command in sql?

1036

Mention what are different methods to trace the pl/sql code?

1207

What is sqlerrd?

968

What is secondary key?

934

How do you determine the current isolation level? : Transact sql

1158