Question: Make sure those querys work in SQL SERVER Q-15. Write An SQL Query To Print Details Of Workers With DEPARTMENT Name As Admin. Ans. The
Make sure those querys work in SQL SERVER
Q-15. Write An SQL Query To Print Details Of Workers With DEPARTMENT Name As Admin. Ans.
The required query is:
Select * from Worker where DEPARTMENT like 'Admin%';
Q-16. Write An SQL Query To Print Details Of The Workers Whose FIRST_NAME Contains A. Ans.
The required query is:
Select * from Worker where FIRST_NAME like '%a%';
Q-17. Write An SQL Query To Print Details Of The Workers Whose FIRST_NAME Ends With A. Ans.
The required query is:
Select * from Worker where FIRST_NAME like '%a';
Q-18. Write An SQL Query To Print Details Of The Workers Whose FIRST_NAME Ends With H And Contains Six Alphabets. Ans.
The required query is:
Select * from Worker where FIRST_NAME like '_____h';
Q-19. Write An SQL Query To Print Details Of The Workers Whose SALARY Lies Between 100000 And 500000. Ans.
The required query is:
Select * from Worker where SALARY between 100000 and 500000;
Q-20. Write An SQL Query To Print Details Of The Workers Who Have Joined In Feb2014. Ans.
The required query is:
Select * from Worker where year(JOINING_DATE) = 2014 and month(JOINING_DATE) = 2;
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
