Trouble with getting this query

[Bucs44]

I'm still new to SQL and am trying to pull up a query that lists the order number, customer ID, and the number of days between order and shipment sorted by longest delivery time to the shortest, for all orders in 1996 only.

I think I have to use DATEDIFF on this but have never used it before - any help would be greatly appreciated.

[iburyak]

Try this:

[PHP]SELECT [order number],[customer ID], DATEDIFF(d, order, shipment) Delivery
WHERE order BETWEEN '1996-01-01 00:00' AND '1996-12-31 23:59'
ORDER BY 3 DESC[/PHP]

[mukesh2706]

Try this:

[PHP]SELECT [order number],[customer ID], DATEDIFF(d, order, shipment) Delivery from [ table name ]
WHERE order BETWEEN '1996-01-01 00:00' AND '1996-12-31 23:59'
ORDER BY 3 DESC[/PHP]

Use Table name

[iburyak]

I don't know what is your data structure. You have to check if names are correct and edit this query accordingly.

[PHP]SELECT [order number],[customer ID], DATEDIFF(d, order, shipment) Delivery
FROM table_name
WHERE order BETWEEN '1996-01-01 00:00' AND '1996-12-31 23:59'
ORDER BY 3 DESC [/PHP]