SQL Interview Questions part 5

You can read part 4 here.

61) Display the names of the employees from department number 10 with salary greater than that of all employee working in other departments.

 62) Display the names of the employees in Uppercase.

63) Display the names of the employees in Lowercase.

64) Display the names of the employees in uppercase.

65) Display the length of Your name using appropriate function.

66) Display the length of all the employee names.

67) select name of the employee concatenate with employee number.

68) User appropriate function and extract 3 characters starting from 2 characters from the following  string ‘Oracle’. i.e the out put should be ‘ac’.

69) Find the First occurrence of character ‘a’ from the following string i.e ‘Computer Maintenance Corporation’.

70) Replace every occurrence of alphabet A with B in the string Allens(use translate function).

71) Display the information from emp table.Where job manager is found it should be displayed as boos(Use replace function).

72) Display empno,ename,deptno from emp table.Instead of displaying department numbers display the related department name(Use decode function).

73) Display your age in days.

74) Display your age in months.

75) Display the current date as 15th August Friday Nineteen Ninety Seven.


Have any question or suggestion for us?Please feel free to post in Q&A Forum
Avatar photo

Shekhar Sharma

Shekhar Sharma is founder of testingpool.com. This website is his window to the world. He believes that ,"Knowledge increases by sharing but not by saving".

You may also like...