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

Categories >> Software >> Databases >> SQL PLSQL
Suggest New Category

Question Posted / ss321

7 Answers
17782 Views
Cap Gemini, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

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

Answer / suma

select distinct(emp_name) from employees;

Is This Answer Correct ?

27 Yes

0 No

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

Answer / os reddy

select distinct * from emp;

OR

select unique * from emp;

Is This Answer Correct ?

6 Yes

0 No

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

Answer / prasi

select distinct(names) from employees;

Is This Answer Correct ?

3 Yes

0 No

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

Answer / klkl

correct
select distinct(emp_name) from employees;

Is This Answer Correct ?

3 Yes

1 No

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

Answer / rakesh

select distinct * from emp;

Is This Answer Correct ?

2 Yes

1 No

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

Answer / dinesh kumar

select distinct * from table_name;

Is This Answer Correct ?

0 Yes

0 No

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

Answer / eshwer

by using min(rowid) or max(rowid). its like deleting duplicate values.

select columns from emp where rowid not in[in] (select maxrow(id) from emp group by columns);

Is This Answer Correct ?

0 Yes

0 No

Post New Answer