Re: Sql Query

In our last gripping episode Mark Sheng <mark_sheng_at_forcorp.com> wrote:
> Hi Paul,
>
> how about this.Maybe it's not a good one,but it can meet your
 requirement.
>
> select max(total) from <table_name> where
> sal<(select max(total) from <table_name> where sal<
> (select max(total) from <table_name> where sal<
> (select max(total) from <table_name>)))
>
> mark
>
> Paul 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.
>
>

I wasn't aware that SAL was a valid column in the specified table.

--
David Fitzjarrell
Oracle Certified DBA


Sent via Deja.com http://www.deja.com/
Before you buy.