Oracle Query for getting CURRENT CTC (Salary) of Each Employee
Posted
by reply2viveksshah
on Stack Overflow
See other posts from Stack Overflow
or by reply2viveksshah
Published on 2010-05-20T11:40:08Z
Indexed on
2010/05/20
11:50 UTC
Read the original article
Hit count: 224
i want current CTC of each employee following is the design of my table
Ecode Implemented Date Salary
7654323 2010-05-20 350000
7654322 2010-05-17 250000
7654321 2003-04-01 350000
7654321 2004-04-01 450000
7654321 2005-04-01 750000
7654321 2007-04-01 650000
i want oracle query for following output
Ecode Salary
7654321 650000
7654322 250000
7654323 350000
thanks in advance
See also
Oracle Query for getting MAximum CTC (Salary) of Each Employee
© Stack Overflow or respective owner