Sorting and then...

From: Wei Weng <wweng(at)kencast(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Sorting and then...
Date: 2001-04-09 23:22:52
Message-ID: 9atfv4$gb0$1@news.tht.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Suppose I have a table

create table test
(
id integer,
name text
);

And I want to get the names of the largest 10 "id"s. How can I do that in
sql?

Thanks!

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Mark Butler 2001-04-10 01:59:56 Inheritance Semantics
Previous Message Peter Eisentraut 2001-04-09 18:38:50 Re: Re: select substr???