如何为Access-Table选择查询？ [英] How to have a Select Query for Access-Table?

问题描述

嗯。我在C＃做一个小项目 - MsAccess-2007数据库。我有一个类似以下方式的结算表

Well. Iam doing a small project in C# - MsAccess-2007 Database. And I have a Billing-Table like the following manner

Bill_No, Bill_Date,Sl_No,Item_Decsirpiton, Quantity, Unit_Rate, Amount, Bill_Value

625, 11/12/2014,  1, PEN       , 2, 10.00, 20.00,   50.00
625, 11/12/2014,  2, PENCIL  , 3, 10.00, 30.00
626, 11/13/2014,  2, PEN      ,  3, 10.00, 30.00, 100.00
626, 11/13/2014,  3, PENCIL ,  3, 10.00, 30.00
626, 11/13/2014,  4, ERASER, 4, 10.00, 40.00
627, 11/14/2014,  1, PEN      ,  3, 10.00, 30.00,   30.00

根据以上数据，Bill_No - 626 Sl_No-1已被删除。



现在我打算从Bill_No字段中选择任意一行



我的意思是我希望输出像以下方式

From the above data, Bill_No - 626 Sl_No-1 has been deleted.

Now my intention is to select an any single row from Bill_No field

I mean I am expecting the Output like the following manner

625, 11/12/2014,  1, PEN       , 2, 10.00, 20.00,   50.00
626, 11/13/2014,  2, PEN      ,  3, 10.00, 30.00, 100.00
627, 11/14/2014,  1, PEN      ,  3, 10.00, 30.00,   30.00

谢谢你帮助

Thanks for the helps

推荐答案

想法是返回每个具有最小SI_No的Bill_No。试试这个：

The idea is to return each Bill_No that has the minimum SI_No. Try this:

SELECT * FROM Table1 t1 WHERE SI_No =
(SELECT MIN(SI_No) FROM Table1 t2 WHERE t2.bill_no=t1.bill_no GROUP BY t2.bill_no)

这篇关于如何为Access-Table选择查询？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！