Use app×
Join Bloom Tuition
One on One Online Tuition
JEE MAIN 2025 Foundation Course
NEET 2025 Foundation Course
CLASS 12 FOUNDATION COURSE
CLASS 10 FOUNDATION COURSE
CLASS 9 FOUNDATION COURSE
CLASS 8 FOUNDATION COURSE
0 votes
1.4k views
in Structured Query Language by (31.3k points)
closed by

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

1 Answer

+1 vote
by (30.9k points)
selected by
 
Best answer

1.

2. Select Name from Employee where Name like

3. Select Name, Design from Employee where Design no’Manager’; 

4. Update Employee set Salary = Salary + Salary * .01;

5. Delete from Employee where Design = ‘Manager’ and Salary < 10000;

Welcome to Sarthaks eConnect: A unique platform where students can interact with teachers/experts/students to get solutions to their queries. Students (upto class 10+2) preparing for All Government Exams, CBSE Board Exam, ICSE Board Exam, State Board Exam, JEE (Mains+Advance) and NEET can ask questions from any subject and get quick answers by subject teachers/ experts/mentors/students.

...