Skip to main content


Eclipse Community Forums

      Home
Home » Archived » BIRT » Determine top 18 values depending on a columns ?
Determine top 18 values depending on a columns ? [message #78538] Mon, 03 October 2005 14:07 Go to next message
Eclipse UserFriend
Originally posted by: sunny.xxxxx.com

Hello,

Iam trying to write a query in Edit DataSet dialog box.
I want to retreive only 18 rows[whose values are greater in the entire
table than rest of them] from 1000 depending on a column.
Can some suggest the query? I know this is not the place to post a sql
question.

Help
Sunny
Solved-Re: Determine top 18 values depending on a columns ? [message #78580 is a reply to message #78538] Mon, 03 October 2005 15:20 Go to previous messageGo to next message
Eclipse UserFriend
Originally posted by: Sunny.xxxxx.com

I got it!!

Sunny wrote:

> Hello,

> Iam trying to write a query in Edit DataSet dialog box.
> I want to retreive only 18 rows[whose values are greater in the entire
> table than rest of them] from 1000 depending on a column.
> Can some suggest the query? I know this is not the place to post a sql
> question.

> Help
> Sunny
Re: Determine top 18 values depending on a columns ? [message #78883 is a reply to message #78538] Tue, 04 October 2005 08:15 Go to previous messageGo to next message
Eclipse UserFriend
Sunny wrote:
> Hello,
>
> Iam trying to write a query in Edit DataSet dialog box.
> I want to retreive only 18 rows[whose values are greater in the entire
> table than rest of them] from 1000 depending on a column.
> Can some suggest the query? I know this is not the place to post a sql
> question.
>
> Help
> Sunny
>
what is the datasource database ?
Re: Determine top 18 values depending on a columns ? [message #78915 is a reply to message #78883] Tue, 04 October 2005 11:02 Go to previous message
Eclipse UserFriend
Originally posted by: Sunny.xxxxx.com

Sql Server


exquisitus wrote:

> Sunny wrote:
>> Hello,
>>
>> Iam trying to write a query in Edit DataSet dialog box.
>> I want to retreive only 18 rows[whose values are greater in the entire
>> table than rest of them] from 1000 depending on a column.
>> Can some suggest the query? I know this is not the place to post a sql
>> question.
>>
>> Help
>> Sunny
>>
> what is the datasource database ?
Previous Topic:Installation
Next Topic:Is there any way to create a CSV format reports in BIRT?
Goto Forum:
  


Current Time: Wed Sep 03 13:56:49 EDT 2025

Powered by FUDForum. Page generated in 0.04248 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top

Sign up to our Newsletter

A fresh new issue delivered monthly