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

Interchange the value of a column Gender in a table where values are Male and Female. So, where the value is Male, it should changed to Female and Female to Male.

4 Answers   Cap Gemini, IBM,

What is the use of nvl function?

0 Answers  

What is nvl function?

4 Answers   Cap Gemini,

Which query operators in sql is used for pattern matching?

0 Answers  

What is multiple partition?

0 Answers  




how to escape special characters in sql statements? : Sql dba

0 Answers  

How many types of literals are available in pl sql?

0 Answers  

What is fmtonly in sql?

0 Answers  

Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.

0 Answers  

What is an exception in pl/sql?

0 Answers  

Who developed sql?

0 Answers  

how to calculate expressions with sql statements? : Sql dba

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories