Скачать или смотреть 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...