Re: hi ........i have a query related to MS reporting services

> 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