如何在Sql server 2008 r2中获取最小id行 [英] How to take minimum id rows take in Sql server 2008 r2

查看:183
本文介绍了如何在Sql server 2008 r2中获取最小id行的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

亲爱的朋友们,



我需要使用sql查询检索最小Id行..我试过这个查询:



  SELECT  MIN(Id),item_code,item_name,item_price,StockInHand,actv_code,actv_name 来自股票
group by item_code,item_name,item_price, StockInHand,actv_code,actv_name







无法检索最小Id行,但同时,我删除item_price然后我试了它来。但我必须需要item_price。

解决方案

如果你想要一行返回,那么你可以使用TOP子句来替代它。

< pre lang =SQL> SELECT TOP 1 Id,item_code,item_name,item_price,StockInHand,actv_code,actv_name
FROM 股票
订购 BY ID





如果您想要最低身份证明item_code然后你可以试试像 -

  SELECT  S.Id,S.item_code,item_name,item_price ,StockInHand,actv_code,actv_name 
FROM 股票S
INNER JOIN

SELECT MIN(Id),item_code
FROM 股票
GROUP BY item_code
AS T
ON S.Id = T.Id





如果你想要别的东西,请告诉我。



希望,它有所帮助:)


Dear Friends,

I need to retrieve Minimum Id Rows using sql query.. I tried this query:

SELECT    MIN(Id), item_code, item_name, item_price, StockInHand, actv_code, actv_name from Stocks 
group by item_code, item_name, item_price, StockInHand, actv_code, actv_name




can't retrieve Minimum Id Rows, but the same time, I removed item_price then i tried it comes. but i must need item_price.

解决方案

If you want a single row to return then you can do it alternatively using TOP clause.

SELECT TOP 1 Id, item_code, item_name, item_price, StockInHand, actv_code, actv_name 
FROM Stocks 
ORDER BY Id



If you want minimum id with same item_code then you can try something like-

SELECT S.Id, S.item_code, item_name, item_price, StockInHand, actv_code, actv_name 
FROM Stocks S
INNER JOIN 
(
  SELECT MIN(Id), item_code   
  FROM Stocks 
  GROUP BY item_code
) AS T
ON S.Id=T.Id



If you want something else than this, please let me know.

Hope, it helps :)


这篇关于如何在Sql server 2008 r2中获取最小id行的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆