Sign Up Login


  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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 / manoj

Answers were Sorted based on User's Feedback



Table Order_Name has a column Order_Date which gives the date & Time at which the order is pas..

Answer / monalisa dalbehera

select max(Order_Date) from Order_Name ;

Is This Answer Correct ?    13 Yes 3 No

Table Order_Name has a column Order_Date which gives the date & Time at which the order is pas..

Answer / pritesh

select * from order_name where order_date=(select max
(order_date) from order_name)

Is This Answer Correct ?    2 Yes 0 No

Table Order_Name has a column Order_Date which gives the date & Time at which the order is pas..

Answer / gurudath mallya

select * from Order_Name where Order_Date=max(Order_Date);

Is This Answer Correct ?    8 Yes 9 No

Table Order_Name has a column Order_Date which gives the date & Time at which the order is pas..

Answer / pardeeprajan

kindly give a delete option for the users to delete wrong
answer. administrator also should verify the answers regularly

Is This Answer Correct ?    2 Yes 4 No

Table Order_Name has a column Order_Date which gives the date & Time at which the order is pas..

Answer / 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

More SQL PLSQL Interview Questions

How to use sql*plus built-in timers?

0 Answers  

How can we overcome recursive triggers in SQL?

1 Answers   iFlex,

What is difference between mysql and postgresql?

0 Answers  

Which one is better sql or oracle?

0 Answers  

what is normalization? : Sql dba

0 Answers  




What is the maximum number of triggers, you can apply on a single table?

0 Answers  

What is trigger price?

0 Answers  

what is Difference between Having and Where clause?

5 Answers   IBM,

What are the topics in pl sql?

0 Answers  

what is an index? : Sql dba

0 Answers  

I have the table like this S.No Name ID 01 Xyz 123 I want the result as 01Xyz123 How to write the query to retrieve the entire row data in a single column?

1 Answers  

What is nosql db?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories