SQL Query Interview Questions

Table of Contents

21. Select first 3 characters of FIRST_NAME from EMPLOYEE?

SELECT SUBSTR (FIRST_NAME, 0, 3) FROM EMPLOYEE;

22. Get position of ‘o’ in name ‘John’ from employee table?

SELECT INSTR (FIRST_NAME,'o') FROM EMPLOYEE WHERE FIRST_NAME='John';

23. Get FIRST_NAME from employee table after removing white spaces from right side?

SELECT RTRIM (FIRST_NAME) FROM EMPLOYEE;

24. Get FIRST_NAME from employee table after removing white spaces from left side?

SELECT LTRIM (FIRST_NAME) FROM EMPLOYEE;

25. Get length of FIRST_NAME from employee table?

SELECT LENGTH (FIRST_NAME) FROM EMPLOYEE;

26. Get First_Name from employee table after replacing ‘o’ with ‘$’?

SELECT FIRST_NAME, REPLACE (FIRST_NAME,'o','$') FROM EMPLOYEE;

27. Get First_Name and Last_Name as single column from employee table separated by a ‘_’?

SELECT FIRST_NAME|| '_' ||LAST_NAME FROM EMPLOYEE;

28. Get FIRST_NAME, Joining year, Joining Month and Joining Date from employee table?

SELECT FIRST_NAME, 
	TO_CHAR(JOINING_DATE,'YYYY') JOINYEAR ,
	 TO_CHAR(JOINING_DATE,'MON'),
	   TO_CHAR(JOINING_DATE,'DD')     FROM        EMPLOYEE;

29. Get all employee details from the employee table order by First_Name Ascending?

SELECT * FROM EMPLOYEE ORDER BY FIRST_NAME ASC

30. Get all employee details from the employee table order by First_Name descending?

SELECT * FROM EMPLOYEE ORDER BY FIRST_NAME DESC;

Pages: 1 2 3 4 5 6 7 8 9 10

Translate »