176985602337900

Find freelancers. Lose those costly delays.

With 1.7 million freelancers, we'll match you with the perfect talent.

or, Register with Elance »

create PostgreSQL Query to always return the same amount of rows
Sign in to Add to Watch List

IT & Programming > Database Development

View Change History

The client has made the following changes to the job.

Description
Date

Job awarded.

Dec 28, 2012
Close

Job Description

  |  Change History >>

Updated

Close
  • Posted: Fri, Dec 28, 2012
  • Time Left: Closed
  • Location: Anywhere
  • Client prefers freelancers from:
    Anywhere

    You are still able to submit a proposal for this job.

    The client prefers freelancers from
    a different location.

    You're still able to submit a proposal for this job, regardless of your location.
  • Start: Immediately
  • Budget: Less than $500
  • Fixed Price Job
  • Elance Escrow Protection
  • U.S. freelancers must have W9
Sign in to view client's details

i want this query to always return 500 rows!

SELECT
startTime,
sum(something) over (order by startTime)
FROM a_big_table
WHERE identifier = [NUMBER]
GROUP BY starttime;

this statement returns a lot of rows, eg: for
identifier = 50 it returns 54.254 rows
identifier = 42 it returns 5.434 rows
identifier = 12 it returns 1.354.254 rows

the select statement for ALL identifiers should always only return 500 rows!

it should NOT return the top 500, bottom 500, the 500 rows it should return should be equally spread over the whole result table.

Sign in or Register to see more

Desired Skills
PostgreSQL Administration, SQL
Job ID: 36377860
Proposals
Avg $ | High $ | Low $ — Show Pricing
  • Submit Date (Latest)

 Greece  |  
SQL expert, database and query optimizations
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 36378495  |  Submitted: Dec 28, 2012 18:58 ET 
Proposal SEALED

 Palestine  |  
Winner
Commitment , Initiative, Fast , Experienced and hit the ground running . my valuable Customers Feedback , reviews and Job history will make this...
4
  |  
 5.0   |  Private   |  3 Jobs
Bid ID: 36378203  |  Submitted: Dec 28, 2012 18:35 ET 
Delivery
Within 1 day
$30.00
Sign in to Elance and start working on jobs today.
Sign in to view more of the job details and submit a proposal. Once registered, you'll have access to thousands of jobs online or through email.
Are you ready to post a job like this one?
Post a Similar Job »