Tuesday, 8 April 2014

SQL Query

Create Employee table using the following attributes (emp_id, ename, deptno, deptname, job, salary)

Find the employee names and their respective department names.
Query
select ename, deptname
From employee;

Find the name of those employees who are earning more than 20,000
Query
select ename
From employee
Where salary>20000

Find employee names who are working as clerk in CSE department.
Query
select ename,
from employee
where job=’clerk’ AND deptname =’CSE’

Write a query to display the name and salary of employees earning more than 25000.
Query
select name, salary
From employee
Where salary > 25000

Write a query to display the employee name and department number for employee number 5.
Query
select name, dept_id
From employee
Where emp_id =5;

Write a query to display the name and salary for all the employees whose salary is not in the range of Rs 10000 and 15000.
Query
select name, salary
From employee
Where salary NOT BETWEEN 10000 AND 15000

Write a query to display the name and department number of all the employees in department number 8 and 12 in an alphabetical order by name.
Query
select name, dept_id
From employee
Where dept_id = 8 AND dept_id = 12
Order by name;

Write a query to display the employee name, job and joining date of employees joined between june 11, 2010 and july 15, 2010. Also order the result in ascending order of joining date.
Query:
select name, job, join_date
From employee
Where join_date BETWEEN ’11-Jun-2010’ AND ’15-Jun-2010’
Order by Join_Date

Write a query to display the name, job and salary of all the employees whose job is clerk or teacher and whose salary is not equal to 15000.
Query
select name, job, salary
From employee
Where job=’clerk’ OR job=’Teacher’ AND Salary!=15000;


1 comment: