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.


Job awarded.

Dec 28, 2012

Job Description

  |  Change History >>


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

    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!

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
Avg $ | High $ | Low $ — Show Pricing
  • Submit Date (Latest)

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

 Palestine  |  
Commitment , Initiative, Fast , Experienced and hit the ground running . my valuable Customers Feedback , reviews and Job history will make this...
 0.0   |  Private   |  0 Jobs
Bid ID: 36378203  |  Submitted: Dec 28, 2012 18:35 ET 
Within 1 day
Elance is now an Upwork company.
Upwork is the choice of 4M+ clients. Get started working on Upwork today.
Are you ready to post a job like this one?
Post a Similar Job »