topic Re: Open SQL , Selecting Values Problem in Application Development and Automation Discussions

Open SQL , Selecting Values Problem

Former Member — Fri, 07 Jul 2006 09:14:11 GMT

Hello,

I have a table like the following

Book ID Min Value

5705 10.00

5705 15.00

5705 22.00

5706 10.00

5706 50.00

If I have a value, such as 8.00, how can I use a single select to bring back just one record, in this case it would be the Minimum Value 10.00 only, ie it has to be less than or equal to the minimum value , and the lowest figure?

Thanks

Re: Open SQL , Selecting Values Problem

Former Member — Fri, 07 Jul 2006 09:27:14 GMT

PARAMETER: p_bookid.

DATA: l_minvalue.

SELECT MIN( minvalue ) INTO l_minvalue FROM DBTAB WHERE bookid = p_bookid GROUP BY bookid.

ENDSELECT.

-Kiran

Re: Open SQL , Selecting Values Problem

Former Member — Fri, 07 Jul 2006 12:56:37 GMT

hi ,

u can use following select query to get the Desired OUTPUT.

TABLES : DBTAB.

DATA: l_book_id,l_minvalue.

SELECT book_id minvalue INTO l_book_id l_minvalue FROM DBTAB WHERE minvalue = select min( minvalue ) from DBTAB.

ENDSELECT

Regards

vikas.