获取最大值和最小值 [英] getting max and min values

问题描述

使用以下代码从列名请求日期获取最小值和最大值.但我两者的值都相同.

  ALTER 
过程 [dbo].[test_GetOrders]
(
 @ cust_id 
 int 
)
 AS 
开始

选择
o.ORD_ID，
min(ODD_RequestDate)作为 min_date，

max(ODD_RequestDate) as  max_date，

count(*)为 no_of_items
 FROM 
dbo.Orders  as  o  JOIN  Orderdetails  as  c 打开 c.ODD_ORD_ID = o.ORD_ID
位置 ORD_CUS_ID = @ cust_id
组 按 o.ORD_ID
结束 

解决方案

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

解决方案

sridevikavalakuntla wrote:

FROM dbo.Orders as o JOIN Orderdetails as c

Try INNER JOIN...in place of just JOIN

stil getting the same problem no change in the values

这篇关于获取最大值和最小值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！