Hello,
I have the following sql
select ename ,temp,max(ver) as rv from
table
WHERE id = 5000
AND id2 = 8000
group by ename ,temp
Problem with the above is always gives two records, ideally it should give only one which should be max(ver).
How can I resolve this issue?
Regards