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

Can pl sql procedure have a return statement?

1070

What is sql and how does it work?

1247

What is integrity in sql?

1103

Why do we use function in pl sql?

1112

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

1039

What is the difference between microsoft access and sql server?

1104

what is rollback? : Sql dba

1178

describe transaction-safe table types in mysql : sql dba

1052

What types of commands can be executed in sql*plus?

1151

What do you understand by pl/sql cursors?

1148

What is parallel hint?

1412

how to convert numeric values to character strings? : Sql dba

1154

Are subqueries faster than joins?

1075

Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?

1136

What are the different types of a subquery?

1101