QSL Server SQL语句实例

原创已于 2022-07-28 08:58:25 修改 · 262 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#sql #数据库

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

SqlServer 语句专栏收录该内容

1 篇文章

订阅专栏

本文介绍了在SQLServer中进行模糊查询和连接查询的SQL语句实例，包括带参数的多表模糊查询和内连接查询，适用于数据检索和分析场景。

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'