> 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