Oracle Query for getting MAximum 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:18:34Z
Indexed on
2010/05/20
11:20 UTC
Read the original article
Hit count: 279
i want maximim 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 out put
Ecode Salary
7654321 650000
7654322 250000
7654323 350000
thanks in advance
© Stack Overflow or respective owner