| Subject | Re: [firebird-support] Return Only One Row? |
|---|---|
| Author | W O |
| Post date | 2013-12-21T22:51:08Z |
You have 2 ways:
SELECT
FIRST 1
MyColumns
FROM
MyTable
That's the old way.
SELECT
MyColumns
FROM
MyTable
ROWS
1
That's the new way.
Greetings.
Walter.
On Sat, Dec 21, 2013 at 4:24 PM, firebirddev firebirddev <firebirddev@...> wrote:
Hello.I was wondering how do I limit the data set to only return a single row?So where a table would contain let us say 10 rows, I am only interested in the first row (I will order the data set prior to this).Thanks.