sql.Format("select a.bookname,a.barcode,a.author,a.bookconcern,a.price,b.numbers from tb_bookinfo a inner join (select barcode,sum(numbers) numbers from tb_sell_sub group by barcode)as b on a.barcode = b.barcode and a.bookname = '%s' order by b.numbers desc",c_value);(select barcode,sum(numbers) numbers from tb_sell_sub group by barcode)as b這個(gè)是什么意思呢？on后面的意思我懂
1 回答
斯蒂芬大帝
TA貢獻(xiàn)1827條經(jīng)驗(yàn) 獲得超8個(gè)贊
首先把格式化字符串進(jìn)行格式化，然后再用格式化字符串去做最終轉(zhuǎn)換。
可以這樣：
CString sFmt;sFmt.Format( "%%.%df", n );//假設(shè)n是你要想的小數(shù)點(diǎn)后的位數(shù)，比如3。經(jīng)過這一行之后，sFmt的值應(yīng)該為“%.3f”了。str.Format( sFmt.GetBuffer(), number );//等同于str.Format( "%.3f", number )
添加回答
舉報(bào)
0/150
提交
取消