[SQL] Sorting and then...

[Wei Weng]

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!


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])