How can return max date row
A b c d e
1 2 1-mar-09 5 10
1 2 10-mar-09 5 10
Only using oracle predefined function. Not user defined.
Output:--
A b c d e
1 2 10-mar-09 5 10
Answer Posted / sivaraman (gasc)
select a,b,c,d,e from tbl_name where c = (select max(c)
from tbl_name)
Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
How to use attributes of the implicit cursor in oracle?
How can we view last record added to a table?
What are the differences between date and timestamp in oracle?
hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.
How do you increase the OS limitation for open files (LINUX and/or Solaris)?
What is dynamic proxy?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
What does sharding mean?
How to drop a tablespace?
How to use "for" statements in oracle?
What are the ways tablespaces can be managed and how do they differ?
How many types of auditing in Oracle?
can u send the sql dumps to sivakumarr1987@gmail.com plz help me
why should i declare foreign key constraint as self relation instead of binary relation in tables ?
How to delete a column in an existing table in oracle?