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
What happens if variable names collide with table/column names?
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 many file formats are supported to export data?
For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?
Explain oracle’s system global area (sga).
Explain the use of analyse option in exp command.
How to create a table interactively?
What is java oracle used for?
What is the purpose of save points in oracle database?
How to invoke the data pump export utility?
What is the data pump export utility?
Is rowid unique in oracle?
How to select some columns from a table in oracle?
How to insert multiple rows with one insert statement in oracle?
Explain about integrity constraint?