本文介绍了几种高级SQL查询技巧，包括使用子查询、联接操作以及TOP子句等来实现复杂的数据筛选需求。通过具体示例展示了如何从大量数据中高效地获取所需信息。
select top 5 * from (select top 10 * from login) b
where b.logid>5
select * from login where logid>5 and logid <10
select top 5 * from jobs where (
job_id not in(select top 10 job_id from jobs order by job_id desc))
order by job_id
SELECT TOP 5 *
FROM jobs
WHERE (job_id <
(SELECT MAX(job_id)
FROM (SELECT TOP 10 job_id
FROM jobs
ORDER BY job_id) AS T))
ORDER BY job_id
where b.logid>5
select * from login where logid>5 and logid <10
select top 5 * from jobs where (
job_id not in(select top 10 job_id from jobs order by job_id desc))
order by job_id
SELECT TOP 5 *
FROM jobs
WHERE (job_id <
(SELECT MAX(job_id)
FROM (SELECT TOP 10 job_id
FROM jobs
ORDER BY job_id) AS T))
ORDER BY job_id
扫一扫
1480
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
