Tuesday, September 13, 2011
Find third heighest o_id from test table.......
select TOP 1 o_id from test where o_id not in(select distinct TOP 2 o_id from test order by o_id DESC) order by o_id desc
Subscribe to:
Post Comments (Atom)
CSHARP Code Examples Samples Tutorials
Copyright © C#.NET ASP.NET Articles. All rights reserved.
0 comments:
Post a Comment