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

What is the difference between a database and a relational database?

0 Answers  

Explain clause in sql?

0 Answers  

how many triggers are allowed in mysql table? : Sql dba

0 Answers  

What is data modelling in sql?

0 Answers  

Is it possible to include an insert statement on the same table to which the trigger is assigned?

0 Answers  




Is sql an operating system?

0 Answers  

Whate is use of MOD function in pl/sql.

3 Answers   Oracle,

What is minus?

0 Answers  

What are the two characteristics of a primary key?

0 Answers  

How many indexes can be created on a table in sql?

0 Answers  

what is the difference between union and union all? : Sql dba

0 Answers  

tell us something about heap tables. : Sql dba

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories