Re: Sql Query

From: Mark Sheng <mark_sheng_at_forcorp.com>
Date: Wed, 22 Nov 2000 18:06:40 GMT
Message-ID: <3A1C0BB5.D5DE6076@forcorp.com>

the "sal" should be changed to "total".

David Fitzjarrell wrote:

> 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.
Received on Wed Nov 22 2000 - 12:06:40 CST