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 ?

Koonal saxena
Profile Answers by Koonal saxena Questions by Koonal saxena
Dec 20th, 2012
9
51197

Questions by Koonal saxena answers by Koonal saxena

Oracle

Answer

Showing Answers 1 - 9 of 9 Answers

amr

Jan 20th, 2013

Code
SELECT empname, salarydate, salary, (case when salary < LAG(salary, 1, 0) OVER (ORDER BY empname, salarydate) then increase else decrease end) AS trend


FROM emp;