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
- 4659 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 |
How to run the anonymous block again?
What is bind variable in oracle 11g?
What is the difference between formal parameters and actual parameters?
What is Trace File ?
What is the difference between sharding and replication?
What happens if you use a wrong connect identifier?
when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.
Given two table employee and department EMP ---------------- empid deptid(fk) Dept --------------------- deptid(pk) deptname que-Write a query to find count of employee in each department. Expected Output- deptid countofEmployee --------------------------- 10 57 20 20 30 15
What are joins, explain all types of joins?
When a form is invoked with call_form, Does oracle forms issues a save point ?
HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE
How to select some rows from a table in oracle?
Oracle General 
