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
8914 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

Explain what is dbms?

974

What is use of package in pl sql?

945

Does truncate need commit?

889

What is database sql?

975

What are all the different normalizations?

966

What is the difference between unique and primary key constraints?

1005

What is Materialized View? In What Scenario we Use Materialized View?

9392

What is normalization? How many normalization forms are there?

1009

How do you update a table in sql?

920

How long does it take to learn pl sql?

999

How to look at the current sql*plus system settings?

1076

What is the difference between distinct and unique in sql?

870

What can sql server reporting services do?

1051

What is transaction control language (tcl)?

1069

How many databases can sql express handle?

939