List:General Discussion« Previous MessageNext Message »
From:Waynn Lue Date:November 16 2008 3:51am
Subject:Re: Row before and after?
View as plain text  
Yeah, so a UNION would work, would this solution be faster than using
a subquery (my instinct says yes) but thought I would ask. They both
execute fast on my system so it's hard to say under load.

Thanks,
Waynn

On 11/12/08, Dan Nelson <dnelson@stripped> wrote:
> In the last episode (Nov 12), Waynn Lue said:
>> I'm trying to find the first row before and the first row after a specific
>> row.  Essentially I want to do these two queries, and get each row.
>>
>> SELECT * FROM Users WHERE UserId = <userId> ORDER BY UserId DESC LIMIT 1;
>> SELECT * FROM Users WHERE UserId = <userId> ORDER BY UserId LIMIT 1;
>>
>> Is there any way to combine this into one query?  OFFSET doesn't allow a
>> negative number, which is essentially what I want.
>
> How about joining them with a UNION?  Two queries for the round-trip
> cost of one!
>
> --
> 	Dan Nelson
> 	dnelson@stripped
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
>
>
Thread
Row before and after?Waynn Lue12 Nov
  • Re: Row before and after?Waynn Lue12 Nov
    • Re: Row before and after?Micah Stevens12 Nov
      • Re: Row before and after?Peter Brawley12 Nov
  • RE: Row before and after?Jerry Schwartz12 Nov
  • Re: Row before and after?Dan Nelson12 Nov
    • Re: Row before and after?Waynn Lue16 Nov