27. Get employee details from employee table whose Salary less than 800000 28. Get employee details from employee table whose Salary between 500000 and 800000 29. Get employee details from employee table whose name is 'John' and 'Michael' 31. Get employee details from employee table whose joining month is “January” 32. Get employee details from employee table who joined before January 1st 2013 33. Get employee details from employee table who joined after January 31st 35. Get Joining Date and Time from employee table 36. Get Joining Date,Time including milliseconds from employee table 37. Get difference between JOINING_DATE and INCENTIVE_DATE from employee and incentives table 38. Get database date 39. Get of employees from employee table who has '%' in Last_Name. Tip : Escape character for special characters in a query. 40. Get Last Name from employee table after replacing special character with white space SQL Queries Interview Questions and Answers on "SQL Group By Functions" - Examples 41. Get department,total salary with respect to a department from employee table. 42. Get department,total salary with respect to a department from employee table order by total salary descending SQL Queries Interview Questions and Answers on "SQL Mathematical Operations using Group By" - Examples 43. Get department,no of employees in a salary with respect to a department from employee table order by total salary descending 44. Get department wise average salary from employee table order by salary ascending 45. Get department wise maximum salary from employee table order by salary ascending 46. Get department wise minimum salary from employee table order by salary ascending 47. Select no of employees joined with respect to year and month from employee table
27. Get employee details from employee table whose Salary less than 800000 28. Get employee details from employee table whose Salary between 500000 and 800000 29. Get employee details from employee table whose name is 'John' and 'Michael' 31. Get employee details from employee table whose joining month is “January” 32. Get employee details from employee table who joined before January 1st 2013 33. Get employee details from employee table who joined after January 31st 35. Get Joining Date and Time from employee table 36. Get Joining Date,Time including milliseconds from employee table 37. Get difference between JOINING_DATE and INCENTIVE_DATE from employee and incentives table 38. Get database date 39. Get of employees from employee table who has '%' in Last_Name. Tip : Escape character for special characters in a query. 40. Get Last Name from employee table after replacing special character with white space SQL Queries Interview Questions and Answers on "SQL Group By Functions" - Examples 41. Get department,total salary with respect to a department from employee table. 42. Get department,total salary with respect to a department from employee table order by total salary descending SQL Queries Interview Questions and Answers on "SQL Mathematical Operations using Group By" - Examples 43. Get department,no of employees in a salary with respect to a department from employee table order by total salary descending 44. Get department wise average salary from employee table order by salary ascending 45. Get department wise maximum salary from employee table order by salary ascending 46. Get department wise minimum salary from employee table order by salary ascending 47. Select no of employees joined with respect to year and month from employee table
sql_queries.docx