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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!