Bring Back Only One Record From A Query

From: <aochss_at_my-deja.com>
Date: Tue, 23 Nov 1999 21:22:53 GMT
Message-ID: <81f0j8$ha1$1_at_nnrp1.deja.com>

Howdy,

[Quoted] [Quoted] I am trying to figure out a way of bringing back only the first record of a query without having to use a cursor.

I can't use the Rownum keyword because the sort by is the most important part of the query.

Does anyone have any ideas?

Thanks,

Anton

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Nov 23 1999 - 22:22:53 CET

This message: [ Message body ]
Next message: Tilen Skraba: "Re: Table Aliasing in JDBC/Java"
Previous message: Yungao: "A professional DBA tool, free at http://members.aol.com/yungao"
Next in thread: pberetta_at_my-deja.com: "Re: Bring Back Only One Record From A Query"
Reply: DanHW: "Re: Bring Back Only One Record From A Query"
Reply: pberetta_at_my-deja.com: "Re: Bring Back Only One Record From A Query"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message