Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

SQL Instant Reference

Authors: Gruber, Martin Gruber

2nd Edition

0782125395, 9780782125399

More Books

Students also viewed these Databases questions

Question

3. Write a policy statement to address these issues.

Answered: 1 week ago