SELECT UserReg.username, JobWant.jobname, JobWant.id AS jobid, UserInfo.name, UserInfo.id AS userid, companyInfo.id AS cid FROM ( SELECT ROW_NUMBER() OVER (order by T.id desc)AS Row, T.* from JobWant INNER JOIN companyInfo ON JobWant.compid = companyInfo.id INNER JOIN UserReg ON companyInfo.compID = UserReg.id INNER JOIN UserInfo ON JobWant.id = UserInfo.compid T ) TT WHERE TT.Row between 0 and 1拜谢各位大神了~
解决方案 »
- sql 想得到年月日格式
- SQL2008 - Table 'MSdatatype_mappings' does not exist
- 求一个查询sql
- exists的疑惑
- 我要用sqlserver2005express创建数据库,表,应该怎么做?
- innosetup 连接sqlserver express 2005 数据库
- 请问ORACLE与MSSQL。SERVER主要区别与各自优势。具体使用有什么不同之处
- 求救!为什么我的ACESS数据库文件会莫名其妙的达到25M,我还没输任何数据呢?而生成MDE后只有500K?
- 一个小问题!
- 请问怎样删除重复数据?
- 求生产投料产出跟踪分析表帖子2
- 记录锁的问题
FROM (
SELECT ROW_NUMBER() OVER (ORDER BY T.id DESC) AS Row ,
T.*
FROM JobWant
INNER JOIN companyInfo
ON JobWant.compid = companyInfo.id
INNER JOIN UserReg
ON companyInfo.compID = UserReg.id
INNER JOIN UserInfo
ON JobWant.id = UserInfo.compid
) TT
WHERE TT.Row BETWEEN 0 AND 1
SELECT TT.username,TT.jobname,TT.jobid,TT.name,
TT.userid,TT.cid
FROM
(SELECT ROW_NUMBER() OVER (order by T.id desc)AS Row,
UserReg.username, JobWant.jobname, JobWant.id AS jobid,
UserInfo.name, UserInfo.id AS userid, companyInfo.id AS cid
from JobWant
INNER JOIN companyInfo ON JobWant.compid = companyInfo.id
INNER JOIN UserReg ON companyInfo.compID = UserReg.id
INNER JOIN UserInfo ON JobWant.id = UserInfo.compid) TT
WHERE TT.Row between 0 and 1
TT.userid,TT.cid
FROM
(SELECT ROW_NUMBER() OVER (order by T.id desc)AS Row,UserReg.username, JobWant.jobname, JobWant.id AS jobid,UserInfo.name, UserInfo.id AS userid, companyInfo.id AS cidfrom JobWantINNER JOIN companyInfo ON JobWant.compid = companyInfo.idINNER JOIN UserReg ON companyInfo.compID = UserReg.idINNER JOIN UserInfo ON JobWant.id = UserInfo.compid) TTWHERE TT.Row between 0 and 1顶唐诗!
SELECT TT.*
FROM (
SELECT ROW_NUMBER() OVER (ORDER BY T.id DESC) AS Row ,
UserReg.username , JobWant.jobname , JobWant.id AS jobid , UserInfo.name , UserInfo.id AS userid , companyInfo.id AS cid
FROM JobWant
INNER JOIN companyInfo
ON JobWant.compid = companyInfo.id
INNER JOIN UserReg
ON companyInfo.compID = UserReg.id
INNER JOIN UserInfo
ON JobWant.id = UserInfo.compid
) TT
WHERE TT.Row BETWEEN 0 AND 1
select top 5 * from
(
select id,字段A,字段B,字段C from tab a
union
select 字段A,字段B,字段C from tab b
)as tab1
where
tab1.id not in ( top {0}
select id,字段A,字段B,字段C from tab a
union
select 字段A,字段B,字段C from tab b
)as tab1
把不同表的结果和在一起,再通过union 连接
可以通过C#中sqlstr=string.Format( sql,(i-1)*5) 通过改变{0}中的值进行分页
1、 between....
2、 top 哪种效率高?