Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Sql Query
Hmm... just from one SQL syntax, nohow I guess.
I suggest you do like this
select id,total FROM Table order by total and then make a loop and pick up 1st 4 values, 4th value or whatever you want, and display that, not result of the query.
On Wed, 22 Nov 2000 14:40:53 GMT, Paul <elrik13269_at_my-deja.com> wrote:
>Hi,
>I,m new to sql and wonder if anybody could help me with the following:
>If I had a table with say order id and order total i.e
>
> id total
> 213 567.35
> 345 444.00
> 214 32.99
>and so on how would I find say just the fourth highest total from the
>table without displaying the rest of the table.
>Thanks for any help.
>
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Wed Nov 22 2000 - 14:53:50 CST