Question

Create a Sql query for the table name Employees,Insert the values, alter the table as Employee details, select the staff details according to their age, sort the table according to their payscale

Answer 1

Explanation:

Table name: Employees

Insert values:

Name Age Salary

John 45 30000

Smith 32 40000

Mary 25 50000

Alter table:

Employee details

Name Age Salary

John 45 30000

Smith 32 40000

Mary 25 50000

Select staff details according to their age:

SELECT * FROM Employees WHERE Age>40

Sort the table according to their payscale:

SELECT * FROM Employees ORDER BY Salary