Re: hi ........i have a query related to MS reporting services - Mailing list pgsql-sql

From Magnus Hagander
Subject Re: hi ........i have a query related to MS reporting services
Date
Msg-id 6BCB9D8A16AC4241919521715F4D8BCEA355C9@algol.sollentuna.se
Whole thread Raw
In response to hi ........i have a query related to MS reporting services  (Dinesh Tiwari <tiwaridinesh22@yahoo.com>)
List pgsql-sql
> HI to all of you. I am a new member of this group and this is my
> first mail in this group.I am working in MS Reporting services.And
> i am new in this job.
>
> I have a problem.
> There is a table which has many columns.
> and i have to give selection to client that he can select any top
> 10,25,500,1000, sales  by departmentment there are more than 10
> department and he want to see top ten seelings in each department.
> How i can do it.
> without using top 10 syntax iin query.
> i dont have to use top 10 sales from table syntax.
> so please help me.

Take a look at LIMIT.
http://www.postgresql.org/docs/8.1/interactive/queries-limit.html

//Magnus



pgsql-sql by date:

Previous
From: Aarni Ruuhimäki
Date:
Subject: Re: double precision vs. numeric
Next
From: Andrew Sullivan
Date:
Subject: Re: Create Assertion -- Question from a newbie