Scribd
Upload
4 views2 pages

SQL Queries for Employee Data Analysis

The document contains a series of SQL query tasks and instructions for manipulating and retrieving data from a database. It includes queries for displaying employee details, department names, and using aggregate, text, math, and date functions. Additionally, it covers grouping and joining tables in SQL.

Uploaded by

ayushpandey20072007
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
4 views2 pages

SQL Queries for Employee Data Analysis

The document contains a series of SQL query tasks and instructions for manipulating and retrieving data from a database. It includes queries for displaying employee details, department names, and using aggregate, text, math, and date functions. Additionally, it covers grouping and joining tables in SQL.

Uploaded by

ayushpandey20072007
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

1

10
11

12 Write SQL query to display Ename, Sal, and deptno who are not getting commission from
table empl.
13 Write SQL query to display the details of employees whose name have only four letters.
14 Write SQL query to display the name of departments. Each department should be
displayed once (DISTINCT).
15 Write SQL query to display the name and salary of those employees whose salary is
between 35000 and 40000. (BETWEEN)
16 Write SQL query to display tables data according to ascending order of sal.
17 Queries for Aggregate functions- SUM (), AVG( ), MIN( ), MAX( ), COUNT( ) .
18 TEXT FUNCTIONS ( TRIM FUNCTION, SUBSTR FUNCTION, LEFT FUNCTION,
RIGHT FUNCTION
, MID FUNCTION )
19 MATH FUNCTIONS ( POWER (), ROUND (), MOD () ).
20 DATE FUNCTIONS NOW (), DATE (), MONTH (), MONTHNAME (), YEAR (), DAY (),
DAYNAME ()
21 Querying and manipulating data using Group by, Having, Order by.
22 Create a table DEPT and show Cartesian Product, JOIN (Cartesian Join, Equi Join,
Natural Join)

You might also like