Ben Goswami wrote: > Since mySQL at this time does not support sub query, Do I've to break this > into 2 SQLs and process: > > select question_id from questions where abs_sort_order in (select > min(a.abs_sort_order) from questions a where a.abs_sort_order > 1) > > Ben >
select question_id from questions where abs_sort_order>1 order by abs_sort_order limit 1 should do it (and run fast if there is an index on abs_sort_order). BTW, what does your question have to do with "Bsic RPM installation" ? Regards -- Joseph Bueno --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
