--- On Wed, 1/9/08, Chinyi Woo <[EMAIL PROTECTED]> wrote:
> Does Postgresql support query like SELECT *TOP 3* * FROM
> Individual ? If I use ORDER BY, I have to write non-sql
> code to get the first row in the result set, which I try
> to avoid.
As you have seen, PostgreSQL's implementation of LIMIT predicate can produce
the same results as TOP.
This is another way to get these results using neither TOP or Limit, but the
query will probably not perform as quickly.
SELECT I1.name, ...
FROM Individual AS I1
INNER JOIN Individual AS I2
ON I1.name < I2.name
WHERE --any where criteria you might have
GROUP BY I1.name, ...
HAVING COUNT(*) < 3
ORDER BY I1.name;
Regards,
Richard Broersma Jr.
---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at
http://www.postgresql.org/about/donate
