Interested to Buy Any Domain ? << Click Here >> for more details...
Table Order_Name has a column Order_Date which gives the
date & Time at which the order is passed.Find the table to
write a query to find out the latest order.
- 5 Answers
- 9149 Views
- Thomson, I also Faced
- E-Mail Answers
Answer Posted / akki julak
SELECT ORDER_DATE FROM ORDER_NAME
WHERE ROWID=(SELECT MAX(ROWID) FROM ORDER_NAME);
| Is This Answer Correct ? | 2 Yes | 5 No |
Post New Answer View All Answers
What are local and global Indexes and where they are useful.
Is sql low level language?
What is sqlcommand?
What is a loop in sql?
how to see the create table statement of an existing table? : Sql dba
What are triggers and its uses?
how many tables will create when we create table, what are they? : Sql dba
Is it possible to create startup or shutdown trigger for on-schema?
What is parallel hint?
What is pl sql in oracle?
1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...
What is numeric function sql?
What is the difference between a primary key and a clustered index?
tell us something about heap tables. : Sql dba
How to write a query to show the details of a student from students table whose
