| Selecting the latest row with same time stamp.. [message #371861] |
Thu, 14 December 2000 16:56  |
Mohammed Azaz
Messages: 1
Registered: December 2000
|
Junior Member |
|
|
I have a table Log which has curdate and log_entry, I need to select the latest entry. My problem is there are two rows with different log_entry but same time stamp, i want to know is there a way Oracle keep time lower than seconds...coz even the to_char() upto seconds has the same time stamp...
Highly appreciate it
Thnx
|
|
|
|
|
|
| Re: Selecting the latest row with same time stamp.. [message #372474 is a reply to message #371861] |
Wed, 14 February 2001 08:29  |
selvan g
Messages: 5
Registered: February 2001
|
Junior Member |
|
|
Hi .. R Sekar..
like if you want to knwo who are the first five senior employees.
select empno,hiredate from emp a
where 5 >= (select count(distinct(hiredate)) form emp b where b.hiredate >= a.hiredate)
order by a.hiredate
pl try this and let me know the result..
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
