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

What is the difference between having clause and where clause?

1008

what does the t-sql command ident_current does? : Transact sql

925

What are the differences between in and exists clause?

1047

In what condition is it good to disable a trigger?

967

What are different sql data types?

951

What is a constraint? Tell me about its various levels.

1081

What are triggers and its types?

992

What is sqlca in powerbuilder?

953

How do I run a sql trace?

905

Is pl sql different from sql?

934

How do I delete a trigger?

911

What is fmtonly in sql?

1003

Which table is left in join?

913

How does sql developer connect to oracle database?

949

What are all ddl commands?

1012