SQL>select add months (sysdate, 3) from dual 82) Display the common jobs from departments number 10 and 20. 81) Display the date three months before the current date. SQL>select to_char (sysdate,'hh:MM:ss') from dual. SQL>SELECT NEXT_DAY (SYSDATE,'SATURDAY') FROMDUAL 80) Display current time.

SQL>select ENAME||' HAS JOINED THE COMPANY ON'||to_char (HIRE DATE,'dayddth Month year') from EMP 79) Find the date for the nearest Saturday after the current date. SQL>select to char (sysdate,'ddth Month day year') from dual 78) Scott has joined the company on Wednesday 13th August nineteen ninety. SQL>select months between (sysdate,'10-sep-77') from dual 76) Display the current date as 15th August Friday Nineteen Ninety Seven. SQL>select to date (sysdate) -to date ('10-sep-77') from dual 75) Display your age in months. SQL>select empno, ename, decode (deptno, 10,'ACCOUNTING', 20,'RESEARCH', 30,'SALES', 40,'OPRATIONS') from emp 74) Display your age in days. Instead of display department numbers display the related department name (Use decode function). SQL>select replace (JOB,'MANAGER','BOSS') FROM EMP 73) Display empno, ename, deptno from emp table. Where the job manager is found it should be displayed as boos (Use replace function). SQL>SELECT INSTR ('Computer Maintenance Corporation’,’ a', 1) FROM DUAL 71) Replace every occurrence of the alphabet A with B in the string Allens (use translate function) SQL>select translate ('Allens','A','B') from dual 72) Display the information from the emp table. SQL>select substr ('oracle', 3, 2) from dual 70) find the First occurrence of character ‘a’ from the following string i.e. SQL>select ename||empno from emp 69) User appropriate function and extract 3characters starting from 2characters from the following string ‘Oracle’. SQL>select length (ename) from emp 68) Select the name of the employee to concatenate with the employee number. SQL>select length ('name') from dual 67) Display the length of all the employee names. SQL>select initcap (ename) from emp 66) Display the length of your name using the appropriate function.

SQL>select lower (ename) from emp 65) Display the names of the employees in the proper case. SQL>select upper (ename) from emp 64) Display the names of the employees in Lowercase. 63) Display the names of the employees in Uppercase. SQL>select ename from emp where deptno=10 and sal>all (select sal from emp where deptno not in 10). 62) Display the names of the employees from department number 10 with salary greater than that of all employees working in other departments. SQL>select ename from emp where deptno=10 and sal>any (select sal from emp where deptno not in 10). SQL>SELECT JOB, SUM (SAL) FROM EMP GROUP BY JOBHAVING SUM (SAL) > (SELECT MAX (SAL) FROM EMP WHERE JOB='MANAGER') 61) Display the names of employees from department number 10 with a salary greater than that of any employee working in other departments. SQL>select ename from emp where deptno= (select deptno from dept where LOC='CHICAGO') 60) Display the Job groups having a total salary greater than the maximum salary for managers. SQL>select ename from emp where deptno= (select deptno from dept where dname='ACCOUNTING') 59) Display the employees names who are working in Chicago. SQL>select ename, sal, job from emp where salin (select max (sal) from emp group by job) 58) Display the employee’s names who are working in the accounting department. SQL>select ename, sal, deptno from emp where sal in (select max (sal) from emp group by deptno) 57) Display the names of the employees who earn the highest salaries in their respective job groups.

SQL>select ename, sal from emp where sal> (select sal from emp where ename='JONES') and sal> (select sal from emp where ename='SCOTT') 56) Display the names of the employees who earn the highest salary in their respective departments. SQL>select ename from emp where job='CLERK' and sal> (select min (sal) from emp where job='SALESMAN') 55) Display the names of employees who earn a salary more than that of Jones or that of salary greater than that of Scott.

SQL>select ename, sal from emp where job='SALESMAN' and sal> (select max (sal) from emp where job='CLERK') 54) Display the names of clerks who earn a salary more than the lowest salary of any salesman. SQL>select empno, ename from emp where job='CLERK' and sal= (select max (sal) from emp where job='CLERK') 53) Display the names of the salesman who earns a salary more than the highest salary of any clerk. SQL>select ename from emp where sal= (select max (sal) from emp) 52) Display the employee number and name for employees working as clerks and earning the highest salary among clerks. 51) Display the name of the employee who earns the highest salary. Questions from basics to advance level with the solution. MySQL Interview Questions List of most frequently asked MySQL Interview Questions.

Mysql interview questions