Typical Query

[najm]

Dears I have a query it#8217;s a typical and based on Auditing query The query is!! let me tell the
Conditions i simply explain it i have a table of Salary in which the fields are EMPNO, ENAME, SALID (Salary Id), ENTRYDATE i want to know those EMP Whose Salary Raised after the Net Salary Entered Let i explain more simply

My Data is

EMPNO ENAME SALID ENTRYDATE
-----------------------------------
1 A Basic 25-JUN-06
1 B HR 25-JUN-06
1 C Convince 28-JUN-06
1 D Others 26-JUN-06
1 E Net Salary 27-JUN-06

I want those Emp whose SALID is raised after Net Salary Entered
So i think when i apply a query(If you guys help me to make it) the result Shows

EMPNO ENAME SALID ENTRYDATE
1 C Convince 28-JUN-06 ---> Because Sal Raised After Net Salary Entrydate

1 Rows Selected

Hope you people help me in this Regard


Cheers

Najm