select distinct * from emp; OR select unique * from emp;

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

Question Posted / os reddy

Answer Posted / os reddy

select distinct * from emp;

OR

select unique * from emp;

Is This Answer Correct ?

6 Yes

0 No

Please Help Members By Posting Answers For Below Questions

define sql insert statement ? : Sql dba

1108

Can we use distinct and group by together?

1146

How do I remove duplicates in two columns?

1202

Is inner join faster than left join?

1287

If a cursor is open, how can we find in a pl/sql block?

1252

Does group by remove duplicates?

1120

Can we rollback truncate?

1083

What is the current version of sql?

1106

What is your daily office routine?

2351

Do we need to rebuild index after truncate?

1151

how to escape special characters in sql statements? : Sql dba

1124

What is the current version of postgresql?

1188

what is dbms? : Sql dba

1069

Is primary key always clustered index?

1101

Can delete statement be rollbacked?

1065