Scribd
Upload
5 views1 page

SQL Queries for Employee Salary Analysis

The document contains fragments of SQL statements related to selecting employee salaries.

Uploaded by

rishabh
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
5 views1 page

SQL Queries for Employee Salary Analysis

The document contains fragments of SQL statements related to selecting employee salaries.

Uploaded by

rishabh
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

UPPER- upeercase

employee not a

Select From Employee e1 where (N-1)=


(Select Count(Distint ([Link])) from employee e2
where [Link] > [Link]

Swlct top1 salary from (select top2 salary from employee order by dec) As my
table orser by salry asc

select distict (salary) from employee order by slary disc limit 1,1

You might also like