sql查询多条数据

最新推荐文章于 2024-07-25 18:23:42 发布

吃范范

最新推荐文章于 2024-07-25 18:23:42 发布

阅读量1.3k

点赞数

分类专栏：代码模块

本文链接：https://blog.csdn.net/fanhuiixa/article/details/82797472

版权

本文介绍了如何使用SQL语句从数据库中查询并获取多条数据，涵盖了SELECT语句的基本用法，包括WHERE子句的应用，以及如何通过ORDER BY和LIMIT来限制返回结果的数量。无论你是初学者还是经验丰富的开发者，这些基本技巧都能帮助你更高效地操作数据库。

摘要由CSDN通过智能技术生成

SELECT IFNULL(TRUNCATE(tudi,2),0.00) AS tudigongxian,
    IFNULL(TRUNCATE(youhuijing,2),0.00) AS youhuijing,
    IFNULL(TRUNCATE(choujiang,2),0.00) AS drawMoney,
    IFNULL(TRUNCATE(tixian,2),0.00) AS tixian, u.tel AS tel,u.headportrait_url AS headportrait_url,
    IFNULL(TRUNCATE(u.balance_gm,2),0.00) AS gouwuAccount, 
    IFNULL(TRUNCATE(u.balance_tx,2),0.00) AS tixianAccount,
    IFNULL(TRUNCATE(u.balance,2),0.00)  AS zongAccount,
    IFNULL(TRUNCATE(chongzhi,2),0.00) AS chongzhi,
    IFNULL(TRUNCATE(orderAmount,2),0.00) AS orderAmount,
    IFNULL(TRUNCATE(leiJiMoney,2),0.00) AS leiJiMoney,
    IFNULL(TRUNCATE(orderMoney,2),0.00) AS orderMoney,
    IFNULL(TRUNCATE(saoMaMoney,2),0.00) AS saoMaMoney,
    IFNULL(TRUNCATE(fanBeiZhuanMoney,2),0.00) AS fanBeiZhuanMoney,
    IFNULL(TRUNCATE(duiHuanMoney,2),0.00) AS duiHuanMoney,
    IFNULL(TRUNCATE(vipMoney,2),0.00) AS vipMoney,
    u.nickname AS nickname,u.id AS id
FROM  
  users u LEFT JOIN 
    (SELECT SU