How to query for this

[Chandu Dharmadhikari]

Hi All

I'm java developer & don't know much about SQL. So plz help me out.

I want a query to select 3 fields from the table having 2 primary_key fields.

This is my table structure

Name Null? Type
------------------------------- -------- ----
EMPCD0 NOT NULL VARCHAR2(6)
WEF0 NOT NULL DATE
PGM VARCHAR2(4)

Now i want to select latest PGM of number of employees

select to_char(max(e.WEF0)),e.EMPCD0 from dismi_tprogempm e group by e.EMPCD0

This query just shows EMPCD0 & WEF0. if we add e.PGM in that it gives error.

Plz suggest a query to find latest records with all information

Thanks In Advance

[Chandu Dharmadhikari]

Hey

I did a query 4 this

Thanx