请写出在class表中查找满足如下条件的记录的SQL语句：这个我写了好长时间都写错了，请各位高手帮忙下

来源：百度知道 编辑：UC知道 时间：2024/05/29 00:32:23
。谢谢请写出在class表中查找满足如下条件的记录的SQL语句：1.返回字段 c_name,c_stu 2.返回记录数：前5条3.查询条件：c_stu值 大于30，并且 c_type值为真，并且c_name字段值中有 “二班”两个字4.查询结果按c_stu正排序，按c_type倒排序（注：在正排序时请不要省略排序关键字）

select top 5 c_name,c_stu from class where c_stu>30 and c_type=ture and c_name like '%二班%' order by c_stu asc,c_type desc

如果order by c_stu 后面排序关键字不写的话,默认是升序.

SELECT TOP 100 PERCENT SUM(saleretail.qty1) AS qty, SUM(saleretail.discountprice1)
AS discountprice, SUM(saleretail.saleprice) AS saleprice,
dbo.Stock.UserCode AS stockid, saleretail.ym
FROM (SELECT SUM(salebill.qty) AS qty1, SUM(salebill.Total) AS discountprice1,
SUM(salebill.qty * salebill.saleprice) AS saleprice,
billindex.ktypeid AS houseid, LEFT(CONVERT(varchar(8), billdate, 120), 7)
AS ym
FROM BillIndex, salebill
WHERE salebill.billnumberid = billindex.billnumberid AND
billindex.billtype = 11 AND billindex.redword = 0
GROUP BY LEFT(CONVERT(varchar(8), billdate, 120), 7), billindex.ktypeid
UNION ALL
SELECT - SUM(salebackbill