Write SQL queries to SQL Query to
1. Create a table Employee with the fields given below.
EmpNo |
Integer |
Name |
Character of size 70 |
Designation |
Character size 30 |
Date of birth |
Date |
Salary |
Decimal (7.2) |
2. List the name of all employees whose name’s second letter is ‘a’.
3. List the Name and Designation of employees whose Designation is not ‘Manager’
4. Increase the salary of ail employees by 10 percent.
5. Remove all managers whose salary is less than Rs. 10,000 from the table