ANY BODY CAN LEARN SOFTWARE TESTING: March 2017

Display all the employees whose name start with P
Display all the analyst and clerks in department 10 and 20
List all the department names which are having blank space in their location and having Dname with at least two EE's
Display all the employees who are having at least two AA's in their job description and salary in the range 1200 to 2800 in dept 10,20,30.
Display all the employees who aren't having any reporting manager with number ending with '8' and not working as 'MANAGER' or 'SALESMAN' in dept 30.
List all the employees who are not getting any commission with their designation neither 'CLERK' nor 'MANAGER' and joined in the year 81 and getting salary more than 1500.
List all the employees whose name is having at least FIVE characters and joined in the year 80 or 81 and having a reporting manager with salary in the range 800 to 2000 in dept 30 or 40.
Display all the employees whose name is having exactly 5 characters and having vowel as middle character
Display all the products whose name is having 2 consecutive underscores
Display all the employees whose name starts with s and does not end with vowel
Display all the products whose name is having ' (single quote) as character
Display all the employees who is working as manager for only one employee
List all the employees where reporting manager ID is ending with the number 8?
List all the employees who's job is salesman and the salary ranges between 1500 to 3000?
List all the employees who are working as managers and salesman in dept 20 & 30 with a salary in the range of 1000 to 3000?
List all the employees who's salary is in the range of 1000 to 2000 in dept 10,20,30 except all clerks?
List all the employees who's names starts with letter A and who's salary is greater than 1000?
List all the student name whose percentage is above 60.
Display all the employee whose name has consecutive m in it.
Display all the employee whose job not belongs to clerk and whose department number is 10 and 20.
List all the employee names who as always two P's and whose salary ranges between 1000 to 3000.
Display all the employee name who don't have commission and working in department 10,20.
list all the employees who is not having reporting manager in dept 20 and 30.
list all the employees whose name does not start with A
display all the employees who have joined in the year 87.
list the employees who have 2 T's in there name.
list all the employees whose employee no is not 7654.
Write a query to display all the salesmen in Dept 30
Write a query to display the employees whose salary is 3000 and 2000
List all the employees whose name has at least one R in it.
List all the employees whose salary is between the range 800 and 2500
List all the employees except who works for Dept 30
Display all the employees who's analyst salary greater than equal to 2000.
Display all the employees who's name end with T and start with A .
Display all the employees who are managers and with their annual salary
Display all the employees who are salesmen and with their annual bonus
Display all the employees who's job name end with second character E
Display all the employee who don't have commission and salary greater than 1000.
Display department name which 'LL' in their Location.
List all the employee whose department is not 20 and name don't have 'M' as first letter.
List all the employee with employee number between 7000 to 8000.
Display all the employee whose salary not in the range from 1500 to 3000.
Display all the employees having greater than 1000 who joined in the month of December and who having reporting manager ?
Display all the employees who have the at least minimum 4 characters in their jobs in the department 20?
List all the employee who are in clerk name end with s except department number 10 ?
Display the employee name should be 5 character?
List all the employee who are getting salary more than highest commission?
Display the sentence with a combination of ename ,sal ,deptno from emp table
Display the employee whose second letter from the beginning is 'A' and the last second letter is 'R'
Display the employee who is earning salary more than 300/- but not more than 3000/-
Display the details of analyst
Display the details of employee who does not take commission
List all employee with annual salary with 500 rs bonus and working as manager joined in the month of April and may
Write a query to display employee whose emp no starts with 78 and 79 whose designation contains at least one E in dept no 20 and 30
List all the manager working in dept 30 and 20 hired between 02-jan-81 to 9-june-81
List the employee job with hiredate whose name starts between A and S working in dept 30 and 20
Write a query to display Dname which contains at least two S and at least one of O or A in their location
List all the manager working in department 20 &30 hired between 02-jan-81 & 09-june-81.
Write a query to display employees whose employee id starts with 78 & 79 whose designation contains atleast one E and working in department 20 & 30.
List the employee job with hiredate whose name starts between 'A' & 'S' working in department 20 & 30 also display commission amount.
Write a query to display name which contains atleast two S & atleast one 'O' or 'A' in their location from department table.
List all the employee with annual salary with 5000rs bonus working as manager joined in the month of april& may.
List all the manager working in department 20 &30 hired between 02-jan-81 & 09-june-81.
Write a query to display employees whose employee id starts with 78 & 79 whose designation contains atleast one E and working in department 20 & 30.
List the employee job with hiredate whose name starts between 'A' & 'S' working in department 20 & 30 also display commission amount.
Write a query to display name which contains atleast two S & atleast one 'O' or 'A' in their location from department table.
List all the employee with annual salary with 5000rs bonus working as manager joined in the month of april& may.
1.List all the employees in dept 20 who have salary less than 500
2.List all the employees who work in dept 10
List all the employees who should report to manager in dept 30
List all the employees whose salry is greater than 3000
List all the employees whose job is analyst
List the employees whose salary in the range of 2000 to 3000 except in dept 10 and 20 in all clerks?
List the employees whose name is having letter 'E' as last but two character?
list all the employees who is having comm in dept 30?
Display all the employee whose earning salary in the range 2500 and 5000 in dept 10 and 20?
list all the employees who are not having reporting manager in dept 20?
List the employees who are '5' no in second position in empno as well as mgr
List all the salgrade whose lowsalary between 1000 to 2000
List the employees name who's are having 3rd letter should 'A' in ename in it
List all the manager who earn less than 3000
List the departments name whos are having 3rd letter should 'n' in it
Display all employees working as a Clerk and Sal not more than 1500 in Dept 10,20,30.
List the employees whose job and Ename having letter 'T'.
List all employees except who are having Commission
Write a query to display Deptname and location having character 'o'.
List the employees whose EmpNo ends with '9' and don't having reporting Manager.
Display all the employees whose joined between Feb and may.
Display all the enames who is having a reporting manager 7698.
Display all the employees whose getting highest salary in department 20 and 30.
List all the enames in department 30 who is having 'A'is one of the character .
List all the department names and location with atleast 2O's.
List all employee whose name starts with k and ends k?
List the department which are having k in their location as well as their department name?
List all the employee is having letter P in the 3rd position?
List all the emp whoes MANAGER employee number between 7698,7839 and salary ends with number 5?
List all the employee whose employee 3rd letter should 2 and his manager annual salary between 30000 to 35000?
List the employee who joined in any year but not belongs to the month of march.
list the employee of department no 30 or 10 joined in the year 81.
Display the names of employee working in department no 10 or 20 or 30 employee working as clerk,salesman or analyst.
List the employees whose names having a character get 'll' together.
Display the details of the employee whose comm is more than their salary.
List all the emp whose name has atleast one 'a' in it.
List all the emp in dept 30 whose sal >= 1500.
List all the emp who are hired in year 81.
List all the analyst in all the department.
List all the emp who are receiving commission.
List the employees whose name does not start with ‘A’
Display all the employee who are joined in JAN.
Display all the employee who are ‘MANAGER’s having E as the last character in ename but salary having exactly 4 character.
List all the employees who are having reporting managers in dept 20.
Display the employees who are having employee no as 7902,7934.
Display all the employees name start with J?
List all the employees whose Commission greater than 100?
List all the employees who have joined in the month of April?
List all the employees whose salary is less than 5000?
List all the employees who have joined in the year 82?
Display all the employees who's job has string 'na' in it.
Display all the employees who joined after Feb 81
Display all the employees except those who are working in dept10&30.
Display all the employees who's commission is not null.
List all the employees who are having reporting manager in dept 10&20.
Display all the employees whose job has string ‘ANA’ in it.
Display all the presidents in department 10.
List the employees whose hire date is before feb 81.
Display all the employees whose name starts with alphabet ‘B’ and ends with a ‘E’ and salary more than 2200.
Display the students whose name is having both first character as ’B’ and last character as a vowel and percentage more than 85 but less than 90.
Select all the employees whose name 4th character starts with 'n' and 1st character start with 'a' or 's' who is working in department 30
List all the employees who is working in department 10 and salary in the rage of 1500 and 5000 and having commission >=500
List the employee except those who are working in dept 10 & 30 and joined after 03-Dec-81
List all the employees whose name having consecutive 'SS' and working in dept 10 whose salary in the range of 500 and 1500
List those employees who are having reporting manager in dept 20,10,30 and name end with 'S' with salary in the range of 2000 and 3000 and joined before 19-June-87
list all the employees whose names end with TT.
list all the employees who have commission of 500 or more.
list all the employees whose salary is between the range 500 and 2000 and belongs to dept 20 and dept 30
list all the salesman and analyst who work in dept 20 and dept 30
list all the employees whose salary is less than 1000 and doesnt belong to dept 20
List all the analyst in department number 20 and having salary greater than 2000.
List all the employees except clerk and analyst and who are not earning salary in the range 1000,3000.
Select all the salesman whose name second character starts with 'A' and who have joined after 20-FEB-81.
List all the employees who are getting 3000 and excess salaries working in department 10 and 20.
Select all the salesman whose name has atleast 1 character 'R' and whose salary is less than 1500 and who are joined after 21-FEB-81.
Write a query to display all the employee details who joined on the year 81 and who has A in his employee name and who gets a commission in the deptno starting with 3.
Write a query to list all the employees who has a manager and has annual salary greater than 10000 and his empID is between 7850 to 7950 and who works as a analyst.
Write a query to list all the department details where department name has E or A and whose location has A and whose deptno is 30.
Write a query to display the employees who has salary less than 2000 and more than 3000 and who joined on NOV or SEP and gets a total monthly salary of less than 2000 including commision.
Write a query to display the employee details and quaterly salary of employees except SALESMAN whose salary i more than 500 but less than 2000 and name starts with S.
list all the names with 'E' present in their last names and their salaries is between 6000 and 12000
hint: login using HR
list all the names of employees who are not working as 'IT Programmer or clerk' and whose sal is more than 3000.
List all the departments starting with location no 1700 and those who have managers.
hint:refer departments table in HR
list all the employee first and last name followed by 'your job is ' and the job along with their salaries greater than 9000
list all the employees first name followed by ' your salary is ' salary and their phone number should contain atleast '1' number somewhere and they must not be Sales representative and hr representative.
Display only the manager codes of the employees whose salary is more than 1000 and hiring date is in the year 81
Display all the employees who report to the manager 7698 and are salesman whose names end with N
Display only the employee name along with the joining date in one column from department 30 and the joining date is in the year 81
List the employees who are Clerks and salary is above 1000 and the hired date is after year 81
List the employees whose salary is between 1000 to 3000 except clerks whose name third character starts with A
List all the employees except salesman and manger in deptno 10
List all the employees who are nor earning salary in the range 1500 and 3000
Display all the employees who are 'MANAGER' having J as first character in ename
List all the salesman in deptno 20 and having greater than 2000
List all the employees whose name starts with 'J' or 'F'
Display the names who are not salesman and analyst and whose salary is more than 1000 working in department 20
display the name whose last but not two is L having some commission and does not belong department 10 and 20
salesman whose salary is ending with 5
employees joined between 80 and 81
list all the salesman whose name consists of n
List all employees who is analyst ,clerk and salesman
List all the employees whose name start with a and end with n
List all the employees Whose name doesn't start with n
List all the employees whose name having 5 characters and salary between 2000 and 20000
Display all employees whose is working as analyst and salesman and working in dept 10 and 20 and salary less than 30000
List all the employees who joined in the year 82 and salary greater than 1000
List all the employees who are salesman and not have any commission
List all the employees whose ratio of commission to salary is greater than 0.5
Display the name and job of the employees whose name second character is 'L' and designation is not 'SALESMAN'
Display all the employees whose name 3rd character is 'R' and getting some commission
SELECT ALL THE EMPLOYEES HAVING COMMISION >1000 JOIN THE JOB ON SEP WHOSE NAME HAVING 'T' LAST BUT TWO AND DEPT NO IS NOT 10 OR 20.
SELECT ALL THE EMPLOYEES WHO JOIN ON DATE 17TH OF ANY YEAR THERE SAL IS EQUAL TO 800 OR 5000 AND THERE DEPTNO NOT EQUAL TO 30
SELECT ALL THE ANALYST WHOSE NAME NOT HAVING 2 CONSECUTINE 'T'S & SAL IS BETWEEN 2000 AND 3000 NOT BELONGS TO DEPTNO 10 OR 20.
SELECT ALL THE EMPLOYEE WHO'S NAME HAVING 2 CONSECUTIVE 'L' THEY NEITHER THE SALESMAN NOR MANAGER HAVING SAL <2000 & JOINING ON 1ST MONTH OF ANY YEAR.
list all the employes whose job is analyst and name starts with the 3 rd character as s and the salary more than 3000.
list all the employees whose job is salesman and hiredate is between 17-dec-18 to 08-dec-81 and deptno as 30
list all the employees whose name is king and the salary is greater than 5000 in the dept 10 and 20
list all the employees whose salary is more then 4000 and commission is null and deptno 10
list all the employees whose reporting manager is not null and the deptno is 10 and 30 and salary is more than 3000
List all the employees in dept 20, earning more than Rs 2500 and not having commission and whose name does not start with ‘S’.
Display all the employee whose earning salary not in the range 2500 and 5000 in dept 10 and 20 whose annual salary is ending with zero.
Display all the employee who are joined after year 81, not working as managers and clerks in dept 10 and 20 with a salary in the range of 1000 to 3000.
List the department names, Locations which are having letter ‘O’ in their locations as well as their department names NOT IN DEPT 20 AND 40.
Select all the employees whose name start with s or A in departmetment 20 and 30. whose are joined before 01-may-81 and after 01-may-80.
List all the employees whose salary is between 1000 and 3000 who are salesman not working in department 10,20 with commission greater than 1000.
List all the department name where department number is greater than 20 and location has atleast one character a.
List all the clerk whose salary is less than 1000 who joined after year 75 and also display their annual salary.
List all the managers,analyst and salesman with annual commission in department 10 and 30 with salary less than 2000 and also display their annual salary of 2 years.
List all the employees who joined afer year 80 and having salary is between 2500 and 4000 and also calculate their salary after six months.
select all the manager whose salary is more than 2500 and department of 20 or 30.
select all the employee whose employee no second digit is 8 and who do not have manager.
select all the employee who work in department 10, 20, 30 and salary is more than 2000 and who are joined in between the year 85 to 87.
list all the department no which is having concatenate L in location name.
list all the employee name who earn more than 1500 salary with commission and working in department 20 and 30 and employee name consists at least one A.
DISPLAY ALL THE EMPLOYEE WHOSE JOB IS CLERK AND ANNUAL SALARY ENDS WITH DOUBLE ZERO?
DISPLAY ALL THE EMPLOYEE NAME WHOSE NAME STARTS WITH 'A' AND SALARY IS RANGE FROM 1000 TO 3000?
DISPLAY EMPLOYEE NAME WHO HAVE EXACTLY 5 CHARACTERS IN THEIR NAME AND WHO WORKS IN DEPT 30?
DISPLAY ALL THE EMPLOYEE WHOSE HAVING REPORTING MANAGER FROM DEPT 20 AND DEPT 30?
DISPLAY EMPLOYEE NUMBER WHOSE NAME DOESN'T ENDS WITH 'S'?
List all employees who is working as clerk in dept 30 and getting salary above 2000
List all employees who are having R as third character in their name, not working as clerk and joined after JUN-81
List all employees who are working under same manager
List all departments which are having A as last before character in their location whose deptno is not 10
List all the managers who don't get a commission in deptno 20 and 30
Display all employees with names containing characters A and R together in it and are getting commission
Display employees with same salary
Display all employees except salary range between 1000 and 5000 and are hired after year 1980
Display all department names and location containing string 'ON' in it
Display all employees who were hired in year 1981 and doesn't have a reporting manager
List all the employees whose getting salary less than 1000 and whose name start with s and end with h and whose working in dept 20.
Display all the employees who are joined after 17-dec-80 and getting salary greater than 2000 and their jobs are analyst. And whose name start with S and end with T.
Display all the employees whose name having atleast one character O and his job is analyst and whose joined after 17-nov-81.
Display all the employees who are salesman, analyst, president and manager and their salary is greater than 1000 along with the employees whose getting commission.
Display all the employees who are not working as manager and analyst in dept 20 and 30 and whose getting salary range between 1000 to 3000 and their name having atleast one O.
list all the employees who are working as salesmen and analyst in dept 20 and 30 with a salary in the range of 1000 and 2000?
list all the employees whose salary is not in the range of 2000 to 3000 in dept 10 except all clerks?
display all the salesman whose quarterly salary ends with 5?
list all the employees from the accounting department and all the employees who are located at boston?
display all the employees whose names start with either w or m?
List all employee number whose employee number ending with at least 4 or 7.
List all employee whose manager is either blake or king
List all employee whose date of joining is before 82 and salary should be more then 2000.
List all employee whose name start with A and has A in between
List all employee whose manager is king and have salary more then 1500.
Display all the employees in department 10 whose salaries are lesser than 1000.
Display all the employees who are getting some commission with their designation is neither manager nor clerk.
Select * from emp where COMM IS not null And JOB NOT IN ('MANAGER','CLERK');
Display all the employees who have joined in the month of December.
Display all the employees whose name is having two consecutive L's .
Display all the employees whose salary is not in the range 2000 and 5000 in department 10 and 20
List all the employees whose job is neither clerk nor salesman in dept 10
List all the location name whose name has atleast one o in department 30 and 40
List all the employees whose job is not clerk and annual salary is more than 1000
Select the employees whose names has 2 consecutive l's
Select all the employees whose emp number end with 9
List all the employees who have joined except on apr and nov an sal more than 2500
List all the employees whose annual salary is equal to or more than 10000.
Display only ename whose name has two consecutive T's .
List ename, job and deptno who does have reporting manager.
Display all the employees whose salary is less than 1000 in dept 10 and 30.
list all the employees whose salary not in range of 1000 and 2000 in dept 10,20 except manager
list all the employees whose salary between 1000 and 1500 working in dept 20,30 except clerk and salesman
list the department names which are having letter 'A' in their locations as well as department name
Display all the employees who are 'manager' having 's' in their last character in ename
Display all the employees who have joined after 02-feb-80 except salesman
What is an Operator in SQL?
What is the purpose of the condition operators BETWEEN and IN?
display all the students who are ME or CIVIL with percentage greater than 75%.
what are the operators in SQL? and list the presidense of operators?
list all employees except those who are not working in dept 10,20 & 30.
Display all the manager whose annual Salary is ending with one ?
Select all the salesman whose salary not between 500 and 1000 in department 20 ?
Display all the employee who are getting some commission with their designation is MANAGER and CLERK ?
List all the salesmen in dept number 10 and having salary greater than 2500 ?
List all the employees whose name starts with ‘k’ or ‘p’ ?
Display employees from whose name is having letter ‘R’ in it?
List all the employees whose name starts with ‘M’ or ‘K’ or 'N' or 'N'?
Display all the employee who are ‘SALESMAN’s having R as the last character in ename but salary having exactly 4 character
Display all the employees whose job has string ‘LES’ in it.
Select all the clerk whose name 4th character start with 'L' and earning salary less than 2000
List the employees whose name doesn't have letter S in it?
List the employees whose salary is not in range from 1000 to 2000 in dept 20 and 30 except all clerk and analyst?
List the employees whose name start with S and ends with H
List the employees whose salary is >1500 and <2500
List the salesman whose ename 2nd char is M and salary in range from 500 to 1500 in it?
List all the employee's names,jobs,salary, who has at least one 's' in their name, earn more than 2000 but not getting any commission in dept 10 and 20.
List out all the managers and clerks who joined in year 81 and earns more than 2000 but not getting any commission.
list all the departments which has at least one 'o' in it's location,which has department number exactly of 2 digits and department name doesn't have any '%' character
list all the employees whose employee number doesn't end with 2, name doesn't end with 'N'or 'k', hired before 81 and earns more than 800 and salary contains at least one zero digit.
List all the employees who has reporting manager, whose name doesn't have any R or A character, who earns between 2000 and 3000, who joined after 80 and before 83, works in department 10,20,30.
Display all the employee who has a joining date on JANUARY, NOVEMBER and APRIL in department 20,10 except 30, also having salary more than 2500.
Display employee name who has their name starting with letters A, J and K also having salary in the range 800 to 2500 with not getting any commission.
Display the employee's name whose gross salary is more than 1500.
Display employee name who has their employee number between 7521 to 7782.
Display employee number who doesn't get any commission in department 30 but getting salary exactly 1600.
List the manager in employee table with yearly bonus of Rs5000 who salary lesser than Rs2500.show annual salary along with employee table.
List all the employees data whose name having 2 L's and matching at least 1 L's in their job's whose deportment number 10.
List all the employees whose are all joining from 30-DEC-81 to 30--DEC-87 and their deportment 20,30 whose Annual salary are Rs 1000 bones of half-off the year . list their Annual salary along with employee data .
List all the employees annual salary who earn the monthly salary Rs 1000 to Rs 5000 .Their deportment number not in 20 . Also date of joining after 01-JAN-82 and before 01-JAN-88.
List all the employees where reporting manager not having NULL Value and deportment number is either 20 or 30 whose employee name start with S's .
LIST ALL DEPT WHICH DO NOT HAVE LETTER 'T' IN LOCATION AS WELL AS DEPARTMENT NAME ?
LIST ALL EMP HIRED BEFORE 83 EARNING SALARY IN RANGE 500 TO 1500 AND GETTING NO COMM?
LIST ALL SALESMAN IN DEPT 30 HIRED IN THE YEAR 81 WHO GET SOME COMM?
LIST ALL EMP IN DEPT 20 AND 30 WHOSE EPMNO ENDS WITH 8 OR 9 EARNING SAL BELOW 5000?
LIST ALL CLERKS AND SALESMAN IN DEPT 10,20,30 WHOSE NAME STARTS WITH LETTER A?
Display employee who work as manager, salesman or analyst and getting sal 3000 or more.
Select * from emp where (job like 'MANAGER' or job like 'SALESMAN' or job like 'ANALYST' and sal >=3000;
Display all Analyst whose name doesn't end with 'S'
Select * from emp where job like 'ANALYST' and Job not like '%S';
Display all employees whose total salary is more than 2000
Select * from emp where (sal + Comm) > 2000;
Display employees whose department between 10 ,20 and salary within 1000 and 4000
Select * from emp where deptno between 10 and 20 and sal between 1000 and 4000;
Display employees having salary of 4 digits and start with 2 and end with 0
Select * from emp where sal like '2%0';
List all the employees who earn 3000 in department no 20
List all the employees whose job does not ends with T
List all the manager and analyst using IN operator
Display all the employees who works salary between 2500 and 5000 in department no 10 & 20
List all employees except president and clerk

ANY BODY CAN LEARN SOFTWARE TESTING

Pages

Saturday 18 March 2017

Questions on Operators