| From: | "Magnus Hagander" <mha(at)sollentuna(dot)net> |
|---|---|
| To: | "Dinesh Tiwari" <tiwaridinesh22(at)yahoo(dot)com>, <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: hi ........i have a query related to MS reporting services |
| Date: | 2006-08-28 08:09:03 |
| Message-ID: | 6BCB9D8A16AC4241919521715F4D8BCEA355C9@algol.sollentuna.se |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Sullivan | 2006-08-28 10:46:03 | Re: Create Assertion -- Question from a newbie |
| Previous Message | Aarni Ruuhimäki | 2006-08-28 08:08:50 | Re: double precision vs. numeric |