QSL Server SQL语句实例

九米的网络网络

已于 2022-07-28 08:58:25 修改

阅读量177

点赞数

分类专栏： SqlServer 语句文章标签： sql 数据库

于 2022-06-23 16:05:03 首次发布

本文链接：https://blog.csdn.net/qq_33857519/article/details/125428884

版权

SqlServer 语句专栏收录该内容

1 篇文章 0 订阅

订阅专栏

Sql Server SQL语句实例

文章目录

Sql Server SQL语句实例
一、模糊查询，带参查询
二、连接查询

一、模糊查询，带参查询

#普通多表模糊查询，带参数
sql = "SELECT TOP 300 t1.id,t1.write_time,t2.point_num,t1.measurement_time,t1.water_level,t1.water_temperature,t1.voltage,t2.interval FROM live_data as t1,device_user_info as t2 where t1.point_num = t2.point_num and t1.point_num like '%"+point_num+"%' order by id desc"
#连接多表模糊查询，带参数
sql = "SELECT TOP 300 t1.id,t1.write_time,t2.point_num,t1.measurement_time,t1.water_level,t1.water_temperature,t1.voltage,t2.interval FROM live_data as t1 INNER JOIN device_user_info as t2 on t1.point_num = t2.point_num where t1.point_num like '%"+point_num+"%' order by id desc"

二、连接查询

sql = 'SELECT TOP 300 t1.id,t1.write_time,t2.point_num,t1.measurement_time,t1.water_level,t1.water_temperature,t1.voltage,t2.interval FROM live_data t1 INNER JOIN device_user_info as t2 on t1.point_num = t2.point_num order by id desc'