Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > IBM DB2 > Re: Question ab...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 4 of 12 Topic 8829 of 9520
 Post > Topic >>

Re: Question about MIN/MAX optimization

by Serge Rielau <srielau@[EMAIL PROTECTED] > Apr 25, 2008 at 11:52 AM

Try this then:
SELECT *
   FROM (SELECT abc FROM T WHERE ID = ?
           ORDER BY id DESC, abc DESC FETCH FIRST ROW ONLY) AS Z,
         (SELECT abc FROM T WHERE ID = ?
           ORDER BY id ASC, abc ASC FETCH FIRST ROW ONLY) AS Y

-- 
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab




 12 Posts in Topic:
Question about MIN/MAX optimization
 Michel Esber <michel@[  2008-04-25 08:05:00 
Re: Question about MIN/MAX optimization
 Serge Rielau <srielau@  2008-04-25 11:15:27 
Re: Question about MIN/MAX optimization
 Michel Esber <michel@[  2008-04-25 08:41:47 
Re: Question about MIN/MAX optimization
 Serge Rielau <srielau@  2008-04-25 11:52:07 
Re: Question about MIN/MAX optimization
 Michel Esber <michel@[  2008-04-25 09:00:01 
Re: Question about MIN/MAX optimization
 "Dan van Ginhoven&qu  2008-04-25 16:34:10 
Re: Question about MIN/MAX optimization
 "Dan van Ginhoven&qu  2008-04-25 17:03:10 
Re: Question about MIN/MAX optimization
 Michel Esber <michel@[  2008-04-25 09:58:22 
Re: Question about MIN/MAX optimization
 Serge Rielau <srielau@  2008-04-25 19:10:25 
Re: Question about MIN/MAX optimization
 Michel Esber <michel@[  2008-04-26 08:18:19 
Re: Question about MIN/MAX optimization
 Serge Rielau <srielau@  2008-04-26 11:57:00 
Re: Question about MIN/MAX optimization
 Michel Esber <michel@[  2008-04-26 08:20:15 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup
Contact
tan12V112 Tue Dec 2 21:20:50 CST 2008.