How can you select unique records from a table?



How can you select unique records from a table?..

Answer / 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

Post New Answer

More SQL PLSQL Interview Questions

How to fetch alternate records from a table?

1 Answers  


What is left join example?

1 Answers  


Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?

1 Answers   MCN Solutions,


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

1 Answers  


What are the benefits of triggers?

1 Answers  


How is a process of pl/sql compiled?

1 Answers  


What does t sql mean?

1 Answers  


how to create a test table in your mysql server? : Sql dba

1 Answers  


Explain the significance of the & and && operators in pl sql.

1 Answers  


Can we call dml statement in function?

1 Answers  


How to disable a trigger name update_salary?

1 Answers  


What are the usages of sql?

1 Answers  


Categories