Write a MySQL statement to select data of all departments in ascending order by name and age

MySQL Exercises

• Write a mysql statement to find the concatenated first_name, last_name where age of the employee is greater than 30
• Write a mysql statement to get user, current date and mysql version
• Write a mysql statement to get item id, item, price of the most expensive item
• Write a mysql statement to create a new user and set password and privileges for an existing database
• Write a mysql statement to select data of only CS OR IT departments
• Write a mysql statement to select data of only students with age 22
• Write a mysql statement to select data of only students with age either in 22,23,24 and department is 'EC'
• Write a MySQL statement to select data of all departments in descending order by age
• Write a MySQL statement to select data of all departments in ascending order by name and age
• Write a mysql statement to determine the age of each of the students
• Write a mysql statement to retrieve name beginning with 'm'
• Write a mysql statement to find the name, birth, department name, department block from the given tables
• Write a mysql statement to get name of students containing exactly four characters
• Delete duplicate row from MySQL table
• Display the alternate rows from MySQL table
• MySQL update multiple rows in one query
• MySQL get nth highest paid and nth lowest paid salary
• Display the 3rd row from the MySQL 'empdata' table
• Display from the 4rd row from the MySQL 'empdata' table, set limit 3
• Display from the 5th row from the MySQL 'empdata' table, set limit 2 and order by name
• Display details of first 5 highly paid employees using MySQL

This question belongs to these collections

• MySQL Exercises

Similar questions