getting max and min values

See more:

Oracle

hi iam using the below code to get min and max values from the column name request date. but iam getting same values for both.

ALTER
PROCEDURE [dbo].[test_GetOrders]
(
@cust_id
int
)
AS
BEGIN

SELECT
o.ORD_ID ,
min(ODD_RequestDate) as min_date,

max(ODD_RequestDate) as max_date,

count(*) as no_of_items
FROM
dbo.Orders as o JOIN Orderdetails as c ON c.ODD_ORD_ID = o.ORD_ID
WHERE ORD_CUS_ID=@cust_id
GROUP By o.ORD_ID
end