Re: Getting the first row from a select

From: Darshan Desai <darshan.desai_at_usa.net>
Date: 1998/10/09
Message-ID: <er$B5w489GA.149@uppssnewspub05.moswest.msn.net>#1/1

Yes, you can do this by issuing this query.

query:

---

SELECT TOP 1
Company_Name
FROM Company
WHERE Company_Name >=
'Whatever was entered'
ORDER BY Company_Name ASC;

---

Darshan Desai
darshan.desai_at_usa.net

DET wrote in message <6v0vgc$7r2_at_netaxs.com>...
>Maybe I'm missing something obvious....
>
>I'm trying to write a VB program that will get the first record from a
 query
>something like:
>
>select * from COMPANY where COMPANY_NAME >= 'whatever was entered';
>
>The user will enter part of a name, and the VB program should retrieve the
>first record >= the string entered. It is *not* a requirement that the
>retrieved record be LIKE 'whatever%' (I'm trying to make this
>general-purpose).
>
>Of course, the COMPANY file may be exceptionally huge, so I don't want to
>just download the entire set of records that matches the above inquiry.
>Intuitively, I would have liked to be able to say:
>
>select * from COMPANY where COMPANY_NAME >= 'whatever' and ROWNUM = 1 order
>by COMPANY_NAME;
>
>but it turns out this doesn't work - ROWNUM is assigned before the sort is
>done.
>
>I'm fairly sure I'm not the first person who's run into this :-) but I'm
 not
>conversant enough with SQL yet to know how to do it. I have some vague idea
>of making it a compound statement using MAX() or MIN() to pull out the
 exact
>ID in the inner statement and using that to pull up an exact match in the
>outer statement, but my head starts to hurt when I try to formulate it.
>
>Any advice or suggestions?
>
>
>
>
>
Received on Fri Oct 09 1998 - 00:00:00 CDT