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 best sql course?

1064

what is schema? : Sql dba

1163

how to start mysql server? : Sql dba

1279

Is primary key always clustered index?

1101

what are the advantages of sql ? : Sql dba

1154

how many tables will create when we create table, what are they? : Sql dba

1156

What is the current version of postgresql?

1188

Can delete statement be rollbacked?

1065

What is your daily office routine?

2353

what are all the common sql function? : Sql dba

1141

Can we use distinct and group by together?

1147

Is inner join faster than left join?

1287

how to use regular expression in pattern match conditions? : Sql dba

1125

define sql insert statement ? : Sql dba

1110

how to escape special characters in sql statements? : Sql dba

1124