sql练习题第二弹

SQL练习题第二弹！
Q1. Write an SQL query to fetch “FIRST_NAME” from Worker table using the alias name as <WORKER_NAME>.
Ans.
The required query is:
Select FIRST_NAME AS WORKER_NAME from Worker;
Q2. Write an SQL query to fetch “FIRST_NAME” from Worker table in upper case.
Ans.
The required query is:
Select upper(FIRST_NAME) from Worker;
Q3. Write an SQL query to fetch unique values of DEPARTMENT from Worker table.
Ans.
The required query is:
Select distinct DEPARTMENT from Worker;
Q4. Write an SQL query to print the first three characters of FIRST_NAME from Worker table.
Ans.
The required query is:
Select substring(FIRST_NAME,1,3) from Worker;
Q5. Write an SQL query to find the position of the alphabet (‘a’) in the first name column ‘Amitabh’ from Worker table.
Ans.
The required query is:
Select INSTR(FIRST_NAME, BINARY'a') from Worker where
FIRST_NAME = 'Amitabh';
Notes.
• The INSTR method is in case-sensitive by defaul

您好！
本帖隐藏的内容需要积分高于 188 才可浏览
您当前积分为 0。
使用VIP即刻解锁阅读权限或查看其他获取积分的方式

游客，您好！
本帖隐藏的内容需要积分高于 188 才可浏览
您当前积分为 0。
VIP即刻解锁阅读权限 或 查看其他获取积分的方式
Unlock interview details and practice with AI
Curated Interview Questions from Top Companies

with salaries >= 50000 and <= 100000.
Ans.
The required query is:
SELECT CONCAT(FIRST_NAME, ' ', LAST_NAME) As
Worker_Name, Salary
FROM worker
WHERE WORKER_ID IN
(SELECT WORKER_ID FROM worker
WHERE Salary BETWEEN 50000 AND 100000);
Q23. Write an SQL query to fetch the no. of workers for each department in the descending order.
Ans.
The required query is:
SELECT DEPARTMENT, count(WORKER_ID) No_Of_Workers
FROM worker
GROUP BY DEPARTMENT
ORDER BY No_Of_Workers DESC;
Q24. Write an SQL query to print details of the Workers who are also Managers.
Ans.
The required query is:
SELECT DISTINCT W.FIRST_NAME, T.WORKER_TITLE
FROM Worker W
INNER JOIN Title T
ON W.WORKER_ID = T.WORKER_REF_ID
AND T.WORKER_TITLE in ('Manager');