按时间排序,然后top 3吧,呵呵。
解决方案 »
- 求高手解答。谢谢!
- ibatis sqlMap中文乱码
- 请教ActionForm问题
- JAVA编程题(李白喝酒)
- SSH刷新之后出现 org.hibernate.exception.GenericJDBCException: could not inspect JDBC autocommit mode
- 急啊?一个送分问题:上传的图片写入数据库,并且从数据库中读出显示在jsp页面上的问题?
- webwork中的一个奇怪现象!!
- 800分问2个问题,如果搞不定up有分
- 有关Struts的问题
- weblogic下怎么布署servlet请讲具体点
- 困扰已久的问题!~~请高手帮助解决!~谢谢
- 学习web service遇到的问题
select * from a where id in(ID-1,ID,ID+1)
呵呵 ~
ro=====select ro from (select rownum ro,ID from A) t where ID='****';
select * from (select rownum ro,ID from A) t where ro in(ro-1,ro,ro+1)
select top 1 *
FROM dbo.TRN_SaleLangAnswer
WHERE (Updatedate < (SELECT Updatedate
FROM dbo.TRN_SaleLangAnswer
WHERE (ID = '3') ) )
order by Updatedate desc ) as t1UNION ALLSELECT *
FROM dbo.TRN_SaleLangAnswer
WHERE (ID = '3')UNION ALLSELECT * from (
select top 1 *
FROM dbo.TRN_SaleLangAnswer
WHERE (Updatedate > (SELECT Updatedate
FROM dbo.TRN_SaleLangAnswer
WHERE (ID = '3') ) ) ) as t2另一种方法就是分成三个SQL语句最后还有一个方法就是用游标。。
where id=8 or id=(select min(id) from 表 where id>8)
or id=(select max(id) from 表 where id<8)