Perform in sqlyog ultimate:

User_ID	User_Name	Salary	Department
201	William	10000	MRKT
202	Michael	20000	HR
203	Anthony	30000	MRKT
204	Aiden	40000	HR
205	Matthew	50000	IT

Perform the following queries for above table:

1. Write a SQL query to display User name who is taking maximum salary.
2. Write a SQL query to display second highest salary from user table.
3. Find names of user starting with ‘A’.
4. Find number of users working in department ‘HR’.
5. Print details of users whose name ends with ‘m’ and contains 6 Alphabets.
6. Print details of users whose salary between 20000 and 50000.
7. How many records do we have?
8. write a query to find How many jobs do we have?     
9. Write a query to find unique jobs from the user table.
10. Add Column Bonus Salary in usertable.

Answer rating: 100% (QA)

1 SELECT UserName MAX Salary FROM USER 2 SELECT MAX ... View the full answer