Un-Answered Questions { MySQL }

Why do we use group by and order by function in mysql?

510


What is join in mysql? What are the different types of join?

501


If we use sum function in mysql, does it return sum of that row or for that column?

520


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

504


What is the use of count function in mysql?

549


Why is the basic difference between left join, right join and inner join?

539


How do we use % when performing a search query?

516


How do we delete a row in a table?

525


What is the difference between char and varchar?

535


What is the default port of mysql server?

501


What are the different column comparison operators in mysql?

476


Write a query to select all teams that won either 1, 3, 5 or 7 games.

803


What are the disadvantages of mysql?

555


Why do we use the mysql database server?

524


What are the technical specifications of mysql?

667