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

Is a view faster than a stored procedure?

713

Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?

943

How to display the records between two range in Oracle SQL Plus?

870

explain about mysql and its features. : Sql dba

743

Does sql*plus also have a pl/sql engine?

767

what are the advantages of mysql in comparison to oracle? : Sql dba

704

What is the difference among union, minus and intersect?

731

What is a dirty read sql?

715

Which query operators in sql is used for pattern matching?

719

what is query cache in mysql? : Sql dba

766

what is a table in a database ? : Sql dba

751

what is the command line end user interface - mysql? : Sql dba

697

What is 19 null in sql?

703

What are the types of functions in sql?

745

What language is oracle sql developer?

714