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

what are rollup and cube in t-sql? : Transact sql

1150

Why do we need unique key in a table?

1005

How much does sqlite cost?

1094

What is sqlerrd?

1015

what are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba

1008

What is the difference between partition and index?

1059

Could you please provide oca (oracle 10g) dumps for my certification ?

5243

can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba

1048

How many types of index are there?

1102

what are the authentication modes in sql server? How can it be changed? : Sql dba

1511

Can we write dml inside a function in sql server?

1004

What is procedure function?

1124

Can we create foreign key without primary key?

1039

What is not null in sql?

1109

which operator is used in query for pattern matching? : Sql dba

1045