1. Categories >> Software >> Databases >> MySQL
  2. Suggest New Category

What do we use to remove duplicate records while fetching a data in mysql ?

Question Posted / deepti kapoor


What do we use to remove duplicate records while fetching a data in mysql ?..

Answer / Ajay Rametkar

To remove duplicate records, you can use the DISTINCT keyword in your SELECT statement.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More MySQL Interview Questions

How to enter microseconds in sql statements?

1 Answers  

What is the difference between CHAR and VARCHAR data types?

2 Answers   Ramco,

Explain advantages of InnoDB over MyISAM?

1 Answers  

How can you make a database as your current database?

1 Answers  

What is innodb_buffer_pool_size?

1 Answers  

What is session variable in mysql?

1 Answers  

Is mysql a free database?

1 Answers  

What is meant by mysqli?

1 Answers  

Use a regular expression to find records. Use “REGEXP BINARY” to force case-sensitivity. This finds any record beginning with r.

1 Answers  

What mysql means?

1 Answers  

Is there a way to see the files which are stored?

1 Answers  

How set mysql root password?

1 Answers  

For more MySQL Interview Questions Click Here
Categories