Scribd
Upload
3 views15 pages

SQL Queries for Employee Management

The document contains various SQL queries related to employee and department data, including selections based on names, job titles, and dates of birth. It also includes operations like counting and ordering results, as well as some references to data structures like dictionaries. Additionally, there are mentions of recursion and truncation without specific context provided.

Uploaded by

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

SQL Queries for Employee Management

The document contains various SQL queries related to employee and department data, including selections based on names, job titles, and dates of birth. It also includes operations like counting and ordering results, as well as some references to data structures like dictionaries. Additionally, there are mentions of recursion and truncation without specific context provided.

Uploaded by

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

Select * From employees where name Like 'A%'

Select city from employee where max(basic salary);


question:my_dict={}
key_list=[100,200,300,400]
value_list=['Bom','LHR','JFK','SIN']
select first_name from employee where dob < '1970-01-01'
order by first_name asc;
Recursion
select count ([Link])
from dept inner join emp
on [Link]=[Link]
where job not in ('manager');
select dept from employees
order by employees asc;
emp where dept=employees
select Ename from emp
where job = 'manager'
order by Ename;
select Ename from emp
where job = 'manager'
order by Ename;
select Dname,count([Link])
from emp inner join dept
[Link]=[Link]
where sales not in (1005,1006)
group by Dname
Order by Dname;
select count(*)
from department;
where department != manager
Truncate
Repeated No
Need
No need
select ename from emp
where dob in('01-08-1999')
order by ename asc;

You might also like