[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-sql
Subject:    Re: [SQL] hi ........i have a query related to MS reporting services
From:       "Magnus Hagander" <mha () sollentuna ! net>
Date:       2006-08-28 8:09:03
Message-ID: 6BCB9D8A16AC4241919521715F4D8BCEA355C9 () algol ! sollentuna ! se
[Download RAW message or body]

> 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


---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

[prev in list] [next in list] [prev in thread] [next in thread]