SELECT ORDER_DATE FROM ORDER_NAME WHERE ROWID=(SELECT MAX(ROWID) FROM ORDE

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.

Question Posted / akki julak

5 Answers
9317 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

Please Help Members By Posting Answers For Below Questions

How subquery works in sql?

1131

What is the trigger in sql?

1004

What is prepared statement in sql?

1105

Is nosql relational?

1002

explain about mysql and its features. : Sql dba

1054

Explain the difference between 'between' & 'and' operators in sql

1047

What is difference between table and view?

1140

How do you optimize a query?

1060

Which normal form is best?

999

How does index help in query performance?

1089

What is serial sql?

1043

How to avoid using cursors?

1179

Which certification is best for sql?

1042

What is spool?

1111

Is sql a backend?

1074