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

Filed under:
|

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

Related posts about Oracle

Related posts about query