pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedhi ........i have a query related to MS reporting services
2+ messages / 2 participants
[nested] [flat]
* hi ........i have a query related to MS reporting services
@ 2006-08-28 07:47 Dinesh Tiwari <tiwaridinesh22@yahoo.com>
0 siblings, 1 reply; 2+ messages in thread
From: Dinesh Tiwari @ 2006-08-28 07:47 UTC (permalink / raw)
To: 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.
Regards
Dinesh Tiwari
---------------------------------
Talk is cheap. Use Yahoo! Messenger to make PC-to-Phone calls. Great rates starting at 1ยข/min.
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: hi ........i have a query related to MS reporting services
@ 2006-08-28 08:09 Magnus Hagander <mha@sollentuna.net>
parent: Dinesh Tiwari <tiwaridinesh22@yahoo.com>
0 siblings, 0 replies; 2+ messages in thread
From: Magnus Hagander @ 2006-08-28 08:09 UTC (permalink / raw)
To: Dinesh Tiwari <tiwaridinesh22@yahoo.com>; 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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2006-08-28 08:09 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-08-28 07:47 hi ........i have a query related to MS reporting services Dinesh Tiwari <tiwaridinesh22@yahoo.com>
2006-08-28 08:09 ` Magnus Hagander <mha@sollentuna.net>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox