Submitted Questions

  • Write the query

    A employee getting variable salary like Jan 3000,Feb 5000,Mar 1000 ,Apr 7000,May 500 write query to display his next salary "increse" or "decrese" as compare to previous month ,three column in the employee table empname ,salarydate,salary ?


    • Aug 5th, 2014

    It can be done by analytical function using the lead function.