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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started