Posts

SQL Queries

-
  Q-1. Write an SQL query to fetch “FIRST_NAME” from the Worker table using the alias name <WORKER_NAME>. ANS. The required query is: Select FIRST_NAME AS WORKER_NAME from Worker ; WORKER_NAME Monika Niharika Vishal Amitabh Vivek Vipul Satish Geetika Q-2. Write an SQL query to fetch “FIRST_NAME” from the Worker table in upper case. ANS. The required query is: Select upper ( FIRST_NAME ) from Worker ; upper(FIRST_NAME) MONIKA NIHARIKA VISHAL AMITABH VIVEK VIPUL SATISH GEETIKA Q-3. Write an SQL query to fetch unique values of DEPARTMENT from the Worker table. Ans. The required query is: Select distinct DEPARTMENT from Worker ; DEPARTMENT HR Admin Account Q-4. Write an SQL query to print the first three characters of  FIRST_NAME from the Worker table. Ans. The required query is: Select substring ( FIRST_NAME , 1 , 3 ) from Worker ; substring(FIRST_NAME,1,3) Mon Nih Vis Ami Viv Vip Sat Gee Q-5. Write an SQL query to find the position of the alphabet (‘a’) in the fi...
Post a Comment
Read more

SQL Data Set

-
  SQL Script to Seed Sample Data: 1. Worker Table CREATE TABLE Worker ( WORKER_ID INT NOT NULL PRIMARY KEY , FIRST_NAME CHAR ( 25 ), LAST_NAME CHAR ( 25 ), SALARY INT ( 15 ), JOINING_DATE DATETIME , DEPARTMENT CHAR ( 25 ) ); INSERT INTO Worker ( WORKER_ID , FIRST_NAME , LAST_NAME , SALARY , JOINING_DATE , DEPARTMENT ) VALUES ( 001 , 'Monika' , 'Arora' , 100000 , '14-02-20 09.00.00' , 'HR' ), ( 002 , 'Niharika' , 'Verma' , 80000 , '14-06-11 09.00.00' , 'Admin' ), ( 003 , 'Vishal' , 'Singhal' , 300000 , '14-02-20 09.00.00' , 'HR' ), ( 004 , 'Amitabh' , 'Singh' , 500000 , '14-02-20 09.00.00' , 'Admin' ), ( 005 , 'Vivek' , 'Bhati' , 500000 , '14-06-11 09.00.00' , 'Admin' ), ( 006 , 'Vipul' , 'Diwan' , 200000 , '14-06-11 09.00.00' , ...
Post a Comment
Read more