To select unique records, use the DISTINCT keyword in your SQL query. For e

How can you select unique records from a table?

Question Posted / Ashish Mandal

Answer Posted / Ashish Mandal

To select unique records, use the DISTINCT keyword in your SQL query. For example: SELECT DISTINCT column_name FROM table_name;

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is the current version of sql?

1106

If a cursor is open, how can we find in a pl/sql block?

1252

Can we use distinct and group by together?

1147

define sql insert statement ? : Sql dba

1110

Is primary key always clustered index?

1101

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

1124

Can we rollback truncate?

1083

Do we need to rebuild index after truncate?

1154

what are all the common sql function? : Sql dba

1141

What is the best sql course?

1064

What is the current version of postgresql?

1188

how to start mysql server? : Sql dba

1279

what are the advantages of sql ? : Sql dba

1154

what are aggregate and scalar functions? : Sql dba

1142

what is bcp? When does it used? : Sql dba

1065