SQL Practice Questions for DBMS Exams
Consider the following relational schema.
Employee(E_ID, E_Name, Dept_Name, Salary, Address)
Now write down the SQL for the following:
i. Display E_Name who is taking maximum salary.
ii. Display all Dept_Name where number of Employees are less than 10.
iii. Display E_Name of employee whose address is either Mechi, Nepalgunj or Pokhara.
iv. Display E_ID and E_Name of employees whose name starts with “S” and Ends with “M”.
v. Increase the salary of employees by 50% whose salary is less than 10000.
This question has been asked in the following examination:
BBA / Second Semester / IT 202: Introductory Database : TU Nepal
For more SQL questions with solutions:
https://webtechparadise.com/questions...
