Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 2 Answers
- 4580 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / apsar
select * from tal_name where rownum<=1 order by c desc
| Is This Answer Correct ? | 0 Yes | 0 No |
Explain what are synonyms used for?
What is query image?
what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?
I'm doing my final year and i ve planned to do an oracle certification , is this the rit tim nd wat's the future scope??
What is the difference between formal parameters and actual parameters?
How to drop a stored function?
What is Private Database Link ?
Explain the use of grant option in exp command.
How to select all columns of all rows from a table in oracle?
diff between DELETE and TRUNCATE?.
14 Answers HCL, Yalamanchili Software,
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
Maximum how many triggers can be updated in table ?
5 Answers Accenture, Cap Gemini,
Oracle General 
