With 1.7 million freelancers, we'll match you with the perfect talent.
The client has made the following changes to the job.
Client prefers freelancers from:
You are still able to submit a proposal for this job.
The client prefers freelancers from
a different location.
i want this query to always return 500 rows!
sum(something) over (order by startTime)
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