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

Why commit is not used in triggers?

1038

What is a .db file?

986

What is sql*loader and what is it used for? : aql loader

1174

What is pl/sql language case sensitive?

1120

What is a temp table?

1024

What is gpt format?

939

Why do we use set serveroutput on?

965

What is the starting oracle error number?

1052

What is difference between left and right outer join?

985

Explain unique key in sql.

1012

How to add new employee details in an employee_details table with the following details

1091

What is primary key and foreign key?

960

What is package in pl sql?

1023

Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?

1015

What is union, minus and interact commands?

1293