Sql All basic queries with answer for mysql, oracal sql etc

You can execute those queries from your oracl sql as well as my sql or in some cases mssql server. hope this queries was helpful for you. In this video i am going to solve these questions answers live that is,
SQL ALL QUERIES
1.WAQTD EMPLOYEE NAMES FROM EMPLOYEE TABLE
2.WAQTD EMPNO FROM EMPLOYEE TABLE
3.WAQTD SAL AND NAME FROM EMPLOYEE TABLE?
4.WAQTD EMPNO,ENAME,SAL,DEPTNO FROM EMPLOYEE TABLE ?
———————-
DISTINCT CLAUSE
—————-
1.WAQTD UNIQUE DEPTNO AND JOB FROM EMPLOYEE TABLE
2.WAQTD UNIQUE SAL FROM THE EMPLOYEESS TABLE
3.WAQTD UNIQUE SAL,JOB FROM OF THE EMPLOYESS
4.WAQTD SALARY AND SALARY WITH A HIKE OF 10%?
5.WAQTD NAME AND SALARY WITH HIKE OF 20%
6.WAQTD NAME ,EMPNO SALARY AND SALARY WITH A HIKE OF 15%?
7.WAQTD NAME SALARY AND SALARY WITH A DEDUCTION OF 10%?
8.WAQTD SALARY & SALARY WITH A REDUCTION OF 20%?
—————————————————————————
ALIAS
—— 1.WAQTD NAME OF THE EMPLOYEES ALONG WITH THEIR ANNUAL SALARY?
2.WAQTD NAME AND JOB FOR ALL THE EMPLOYEES AND THEIR HALF SALARY?
3.WAQTD ALL THE DETIALS OF EMPLOYEE ALONG WITH AN ANNUAL BONUS OF 2000?
4.WAQTD NAME AND SALARY WITH DEDUCTION OF 25%?
———————————————
QUESTIONS ON WHERE CLAUSE
: ————————————–
1.WAQTD THE ANNUAL SALARY OF THE EMPLOYEE WHOS NAME IS SMITH?
2.WAQTD NAME OF THE EMPLOYEES WORKING AS CLERK?
3.WAQTD SALARY OF THE EMPLOYEES WHO ARE WORKING AS SALESMAN
4.WAQTD DETAILS OF THE EMP WHO EARNS MORE THAN 2000
5.WAQTD DETAILS OF THE EMP WHOS NAME IS JONES
6.WAQTD DETAILS OF THE EMP WHO WAS HIRED AFTER 01-JAN-81
7.WAQTD NAME AND SAL ALONG WITH HIS ANNUAL SALARY IF THE ANNUAL
SALARY IS MORE THAN 12000
8.WAQTD EMPNO OF THE EMPLOYEES WHO ARE WORKING IN DEPT 30
9.WAQTD ENAME AND HIREDATE IF THEY ARE HIRED BEFORE 1981
10.WAQTD DETAILS OF THE EMPLOYEES WORKING AS MANAGER
11.WAQTD NAME AND SALARY GIVEN TO AN EMPLOYEE IF EMPLOYEE EARNS
A COMMISSION OF RUPEES 1400
12.WAQTD DETAILS OF EMPLOYEES HAVING COMMISSION MORE THAN SALARY
13.WAQTD EMPNO OF EMPLOYEES HIRED BEFORE THE YEAR 87
14.WAQTD DETAILS OF EMPLOYEES WORKING AS AN ‘ANALYST’
15.WAQTD DETAILS OF EMPS EARNING MORE THAN 2000 RUPEES PER MONTH