我從表中得到最高值和最低值，表也接受空值。我能夠得到最高值但不是最低值。
這是我的表格資料：
PostBidId UserId PostId BidAmount
-------------------------------------------------
1691 159 1239
1684 147 1239 100000000000000
1683 147 1239 12345666666
1680 147 1239 6777777
1682 147 1239 900
1681 147 1239 90000000
我的最高價值是100000000000000，低價值 id 900。
這是我的代碼：
SELECT TOP(1)
BidAmount AS HighestBid, '0' AS LowestBid
FROM
[dbo].[Bids]
WHERE
PostId = 1239 AND BidAmount != ''
ORDER BY
BidAmount ASC
輸出為：100000000000000
SELECT
MIN (BidAmount) AS LowestBid, '0' AS HighestBid
FROM
[dbo].[Bids]
WHERE
PostId = 1239 AND BidAmount != ''
輸出是：100000000000000，我期待的是：900。
uj5u.com熱心網友回復：
SELECT MIN (CAST (BidAmount as bigint)) AS LowestBid, '0' AS HighestBid
FROM [dbo].[Bids]
WHERE PostId = 1239 AND BidAmount != ''
轉載請註明出處，本文鏈接：https://www.uj5u.com/gongcheng/408478.html
標籤：