Tim Moores wrote:Sounds like the text is not properly encoded somewhere along the way. Without seeing the relevant parts of the code, there isn't much we can advise.
Where or what is that? If it's a console of some kind, make sure it can display Unicode characters (most consoles can't). If it's a text file, make sure to open it in an app that can handle Unicode.
Ulf Dittmer wrote:What stops you from doing this? Or do you want to do any of those steps programmatically? In that case we'd need to know what kind of application this is - web, desktop, ... ?
Martin Vajsar wrote:
prajapatisagar Sagar wrote:thanks for the reply but i want to use max(leave_applied_dt) show that it displays the max date first then others
I don't understand your requirement. Do you want just to independently verify that the query does indeed return the max date first?
Martin Vajsar wrote:In Oracle, rownums are assigned to rows before the order by step. You need to order the resultset first and then filter out the rows using rownum: