select JOB_ID from EMPLOYEES select distinct JOB_ID from EMPLOYEES
//retrieve the first name and last name of the.... select LAST_NAME, FIRST_NAME from EMPLOYEES where SALARY>9000 select LAST_NAME, FIRST_NAME, salary from EMPLOYEES where SALARY<50000
select LAST_NAME, FIRST_NAME, salary from EMPLOYEES where SALARY between 4000 and 9000 order by SALARY select * from LOCATIONS SELECT * FROM TABS select * from EMPLOYEES select * from LOCATIONS retrieve location_id street_add all the location in vanice
select * from LOCATIONS
select STREET_ADDRESS,CITY, LOCATION_ID from LOCATIONS where CITY='Venice' or CITY='Roma'
select POSTAL_CODE, LOCATION_ID from LOCATIONS where CITY='Whitehorse' and COUNTRY_ID='CA'
SELECT * FROM DEPARTMENTS
// FIND THE FIRST_NAME & SALARY OF EMPLOYEES WHOSE NAME STARTS WITH 'S' select first_name,salary, last_name from EMPLOYEES where FIRST_NAME LIKE'S%' and SALARY LIKE'6%' AND LAST_NAME LIKE'V%'
//name ends with 'a' select first_name,salary, last_name from EMPLOYEES where FIRST_NAME LIKE'S%' select first_name,salary, last_name from EMPLOYEES where FIRST_NAME like '%a%'
select first_name,salary, last_name from EMPLOYEES where FIRST_NAME like '______' select first_name,salary, last_name from EMPLOYEES where FIRST_NAME like '_a%____'
select LAST_NAME, FIRST_NAME from EMPLOYEES where SALARY>900 and FIRST_NAME LIKE'_a%'
//RETRIEVE DETAILS OF EMPLOYEES WORKING FOR DEPT. HAVING ID = 90,60,100 SELECT * FROM EMPLOYEES WHERE DEPARTMENT_ID NOT IN (60,90,100)
//RETRIEVE TO.NP. OF EMPLOYEES WORKING IN EMPLOYEES TABLE
SELECT COUNT(*) FROM EMPLOYEES
SELECT COUNT (DISTINCT (JOB_ID)) FROM EMPLOYEES
FIND TOTAL SALARY GIVEN TO THE EMPLOYEES GIVEN TO THE EMPLOYEES TBY THE ORGANISATION
SELECT SUM (SALARY) FROM EMPLOYEES SELECT AVG (SALARY) FROM EMPLOYEES
//RETRIEVE
select LAST_NAME, FIRST_NAME, salary from EMPLOYEES order by (FIRST_NAME)
select * from EMPLOYEES where SALARY>5000 order by (SALARY) desc
Q retrieve dept name and location from department table Q LIST THE NAME OF ANALYST AND SALES MAN
SELECT * FROM DEPARTMENTS SELECT DEPARTMENT_NAME , LOCATIONS FROM DEPARTMENTS
select DEPARTMENT_NAME, LOCATION_ID FROM DEPARTMENTS
// FIRST_NAME AND LAST_NAME OF EMPLOYEES WHOSE COMMISSION IS NULL
select * FROM EMPLOYEES WHERE COMMISSION_PCT IS NULL
ReplyDeleteselect LAST_NAME, JOB_ID from EMPLOYEES;
find all the JOB_ID from EMPLOYEES
select JOB_ID from EMPLOYEES
select distinct JOB_ID from EMPLOYEES
//retrieve the first name and last name of the....
select LAST_NAME, FIRST_NAME from EMPLOYEES where SALARY>9000
select LAST_NAME, FIRST_NAME, salary from EMPLOYEES where SALARY<50000
select LAST_NAME, FIRST_NAME, salary from EMPLOYEES where SALARY between 4000 and 9000 order by SALARY
select * from LOCATIONS
SELECT * FROM TABS
select * from EMPLOYEES
select * from LOCATIONS
retrieve location_id street_add all the location in vanice
select * from LOCATIONS
select STREET_ADDRESS,CITY, LOCATION_ID from LOCATIONS where CITY='Venice' or CITY='Roma'
select POSTAL_CODE, LOCATION_ID from LOCATIONS where CITY='Whitehorse' and COUNTRY_ID='CA'
SELECT * FROM DEPARTMENTS
// FIND THE FIRST_NAME & SALARY OF EMPLOYEES WHOSE NAME STARTS WITH 'S'
select first_name,salary, last_name from EMPLOYEES where FIRST_NAME LIKE'S%' and SALARY LIKE'6%' AND LAST_NAME LIKE'V%'
//name ends with 'a'
select first_name,salary, last_name from EMPLOYEES where FIRST_NAME LIKE'S%'
select first_name,salary, last_name from EMPLOYEES where FIRST_NAME like '%a%'
select first_name,salary, last_name from EMPLOYEES where FIRST_NAME like '______'
select first_name,salary, last_name from EMPLOYEES where FIRST_NAME like '_a%____'
select LAST_NAME, FIRST_NAME from EMPLOYEES where SALARY>900 and FIRST_NAME LIKE'_a%'
//RETRIEVE DETAILS OF EMPLOYEES WORKING FOR DEPT. HAVING ID = 90,60,100
SELECT * FROM EMPLOYEES WHERE DEPARTMENT_ID NOT IN (60,90,100)
//RETRIEVE TO.NP. OF EMPLOYEES WORKING IN EMPLOYEES TABLE
SELECT COUNT(*) FROM EMPLOYEES
SELECT COUNT (DISTINCT (JOB_ID)) FROM EMPLOYEES
FIND TOTAL SALARY GIVEN TO THE EMPLOYEES GIVEN TO THE EMPLOYEES TBY THE ORGANISATION
SELECT SUM (SALARY) FROM EMPLOYEES
SELECT AVG (SALARY) FROM EMPLOYEES
//RETRIEVE
select LAST_NAME, FIRST_NAME, salary from EMPLOYEES order by (FIRST_NAME)
select * from EMPLOYEES where SALARY>5000 order by (SALARY) desc
Q retrieve dept name and location from department table
Q LIST THE NAME OF ANALYST AND SALES MAN
SELECT * FROM DEPARTMENTS
SELECT DEPARTMENT_NAME , LOCATIONS FROM DEPARTMENTS
select DEPARTMENT_NAME, LOCATION_ID FROM DEPARTMENTS
// FIRST_NAME AND LAST_NAME OF EMPLOYEES WHOSE COMMISSION IS NULL
select * FROM EMPLOYEES WHERE COMMISSION_PCT IS NULL
https://toffeeshare.com/c/v21UWqH1QC
Delete