如何在Sql server 2008 r2中获取最小id行 [英] How to take minimum id rows take in Sql server 2008 r2
本文介绍了如何在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屋!
查看全文