Re: Whatcha' wanta have?????

"Dirk Moolman" <DirkM@mxgroup.co.za> wrote: > This makes me think of another simple thing: > > Increasing the capability of: select first n * from tablename > > ..... the capability of selecting subsets of data without too much trouble Can you explain what you're thinking of? What do you want that Dorn Bhechsonggram's suggestion does not provide? Or where do you want to use the notation that you can't in PostgreSQL and MySQL? Thanks for the extra information. And thanks for the valuable ideas you're all submitting. No promises, of course, but we're definitely taking notes. -=JL=-

jleffler@us.ibm.com (Jonathan Leffler) wrote in message news:<eab66e61.0402121022.7f9e03d2@posting.google.com>... > "Dirk Moolman" <DirkM@mxgroup.co.za> wrote: > > This makes me think of another simple thing: > > > > Increasing the capability of: select first n * from tablename > > > > ..... the capability of selecting subsets of data without too much trouble > > Can you explain what you're thinking of? What do you want that Dorn > Bhechsonggram's suggestion does not provide? Or where do you want to > use the notation that you can't in PostgreSQL and MySQL? > > Thanks for the extra information. > > And thanks for the valuable ideas you're all submitting. No promises, > of course, but we're definitely taking notes. > > -=JL=- being able to use "first N" in any select, e.g. select * from table_1 where key in (select first 10 key from table_2 order by something); select first N * from table_1 into temp table_temp; etc...