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

Can you rollback after commit?

1053

Is left join same as join?

1039

What is auto increment feature in sql?

1174

explain commit and rollback in mysql : sql dba

1076

What type of database is cloud sql?

1160

what is the difference between truncate and drop statements? : Sql dba

1182

Which software is used for pl sql programming?

1034

Is join same as left join?

1083

How many rows can sqlite handle?

1162

What is the difference between sql, mysql and sql server?

1176

Is inner join faster than left join?

1251

what is a composite primary key ? : Sql dba

1095

How many sql databases can you have on one server?

1155

what are the differences between char and nchar? : Sql dba

1162

What is materialized view in sql?

959