HomePagev2 Forums SQL Discussions SQL Assignment 4

  • SQL Assignment 4

     narendra updated 1 year, 9 months ago 1 Member · 1 Post
  • narendra

    Member
    December 27, 2020 at 6:51 am

    Hello all,

    These are the few questions i am having problem while solving. Need your inputs on these.

    Question 5: Write a query to find the position of the alphabet (‘a’) in the first name column ‘Jane’ from Employee table.
    
    Question 24: Write a query to retrieve of the Employees who are also Managers
    
    Question 25: Write a query to retrieve duplicate records having matching data in some fields of a table.
    
    Question 34: Write a query to determine the 5th highest salary without using TOP or limit method.
    
    Question 39: Write a query to retrieve the first 50% records from a table based on employee id
    
    Question 46: Write a query to retrieve three max salaries from a table
    
    Question 47: Write a query to retrieve three min salaries from a table.
    
    Question 48: Write a query to retrieve nth max salaries from a table.
    

Log in to reply.

Original Post
0 of 0 posts June 2018
Now