select distinct * from table

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

Question Posted / dinesh kumar

Answer Posted / dinesh kumar

select distinct * from table_name;

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How do I run pl sql in sql developer?

1114

Explain cursor types?

1018

Is merge a dml statement?

973

What is multiple columns?

1062

Which is faster union or join?

964

give the syntax of grant and revoke commands? : Sql dba

1149

What is a .db file?

984

How can we connect an Android App to an Oracle database and use the PL/SQL procedural code?

1136

how to extract a unit value from a date and time? : Sql dba

990

How much does a sql dba make? : SQL DBA

937

How do I find duplicates in two columns?

1160

Which operator is used in query for pattern matching?

1087

Can pl sql procedure have a return statement?

1024

what is the different between now() and current_date()? : Sql dba

1012

what is union? : Sql dba

1023