Re: Query - Mailing list pgsql-general

From Mitch Vincent
Subject Re: Query
Date
Msg-id 001601c13ca4$bb0e1550$1e51000a@mitch
Whole thread Raw
In response to Query  ("Tamara D. Blum" <tblum@jus.gov.ar>)
List pgsql-general
>     I'm trying to execute the following query:
>         "SELECT TOP 10 * FROM table1"

SELECT * FROM table1 LIMIT 10

 -- might give you what you're looking for.. I've not seen TOP, though I
could guess where it comes from (Oracle?) -- top seems to imply order so you
might want to ORDER BY something in the query before you LIMIT ...

-Mitch



pgsql-general by date:

Previous
From: "Tamara D. Blum"
Date:
Subject: Query
Next
From: "Joe Conway"
Date:
Subject: Re: Query