Scribd
Upload
9 views1 page

Query

The document contains a series of SQL queries related to employee data management. It includes selections based on department, job title, hire dates, and designations, as well as an update command for an employee's designation. The queries aim to retrieve and manipulate employee records from a database.

Uploaded by

manharakshat
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
9 views1 page

Query

The document contains a series of SQL queries related to employee data management. It includes selections based on department, job title, hire dates, and designations, as well as an update command for an employee's designation. The queries aim to retrieve and manipulate employee records from a database.

Uploaded by

manharakshat
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
You are on page 1/ 1

Q5- select * from employee where Dept_name="Mech";

Q6- select Job_ID from employee where E_Name="James";


Q7- select * from employee where Dept_name="Sales";

PG 20>>

update employee set designation="Cleark" where E_no=1;

Q1- select E_No, E_Name, Salary from employee where designation="Manager";


Q2- select * from employee where salary >(select min(salary) from employee where
dept_name="Mech");
Q3- select * from employee where Hire_Date>"2020-11-23" order by designation asc;
Q4- select E_No, E_Name, (Hire_Date-"2024-04-07") as Experience , salary/30 as
Daily_Salary from employee;
Q5- select * from employee where Designation="Cleark" or designation= "Analyst";
Q6- select * from employee where Hire_Date="1981-05-01" or Hire_Date="1981-12-03"
or Hire_Date="1981-12-17" or Hire_Date="1980-01-19";
Q7- select * from employee where Dept_No="D10" or Dept_No="F24";
Q8- select E_Name from employee where E_Name like "M%";
Q9- select substr(E_Name, 1, 3) from employee where E_Name like "R%";
Q10- select * from employee where Designation="Manager" and Designation="President"
order by salary asc;

You might also like