• Ger Salaries of each employee for last 3 months

 

 

 

 

  • SQL query that returns employee columns, with a specific constraint on the age column: the age of each subsequent employee is the sum of the ages of all the preceding employees in the result set.
    • Table will be
    • Query
    • End Result will be

 

 

 

  • Get only Subject in which student get maximum marks
    • Student table
    • Subject with Marks table
    • Query
    • End Result will be

 


Related Question