MySQL Exercises

Title
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

Questions

Views

Best Answers

Points