看《21天学通SQL SERVER》练习代码1

SELECT TOP 100 *
FROM lianxi.dbo.zldf
WHERE 分类='ershoufang'
ORDER BY 发送消息时间 DESC



SELECT DISTINCT riqi,平台,分类
FROM lianxi.dbo.zldf
ORDER BY riqi DESC,平台 DESC,分类 DESC


--检索不同的值
SELECT DISTINCT 分类
FROM lianxi.dbo.zldf



SELECT TOP 10 *
FROM lianxi.dbo.zldf
WHERE 平台 like 'APP%' AND 聊天记录 like '%中原%'
ORDER BY 发送消息时间 DESC


SELECT COUNT(DISTINCT 分类) AS fenleishu
FROM lianxi.dbo.zldf
WHERE 分类<>''


SELECT TOP 10 *
FROM lianxi.dbo.zldf
WHERE 分类=''


--通配符%
SELECT DISTINCT riqi,平台,分类,聊天对象
FROM lianxi.dbo.zldf
WHERE 分类 like 'xinfang%'


--通配符_(下划线)
SELECT DISTINCT riqi,平台,分类,聊天对象
FROM lianxi.dbo.zldf
WHERE 分类 like 'xinfang___'


--in操作符
SELECT DISTINCT 平台,分类,聊天对象
FROM lianxi.dbo.zldf
WHERE 分类 in ('ershoufang','xiaoqu','zufang')
ORDER BY 分类



--方括号（[ ]）通配符
SELECT DISTINCT 分类
FROM lianxi.dbo.zldf
WHERE 分类 like '[em]%'

--START