This website requires Javascript to function properly. Please go to the setting of your web browser and enable Javascript for this website.
×
Loading...
Close
Home
Share
Will this work? select A, B from (select A, B, lag(A, 1) over (order by A) as A1, lead(A, 1) over (order by A) as A2 from T) where A = A1 or A = A2
fromztoa
(fromZtoA)
(#260764@0)
Last Updated: 2001-11-14
This post has been archived. It cannot be replied.
Share
Share Online by QR Code
Report
Replies, comments and Discussions:
闲来无事, 出道ORACLE SQL的题考考大家. 这是在下几个月前工作中遇到的问题, 看似简单, 其实不然.
枫下论坛主坛
/
工作学习
/
IT技术讨论