Difference between revisions of "Get the 11th to the 20th rows of the cia table - by population."

From SQLZOO
Jump to: navigation, search
 
Line 29: Line 29:
 
</source>
 
</source>
 
<div class="ecomm e-sqlserver" style="display: none">We select the bottom 10 of the top 20 - we end up with the list in the wrong order - this can be fixed with another nested select.</div>
 
<div class="ecomm e-sqlserver" style="display: none">We select the bottom 10 of the top 20 - we end up with the list in the wrong order - this can be fixed with another nested select.</div>
<div class="ecomm e-oracle" style="display: none">You cannot usefully use rownum in the WHERE clause - however you can refer to it in an outer query.
+
<div class="ecomm e-oracle" style="display: none">You cannot usefully use rownum in the WHERE clause - however you can refer to it in an outer query. People generally need guarantees that they receive good grades when order [http://primewritings.com custom term paper] or purchase custom academic papers. Alas, not every academic writing service is able to give those guarantees.  
 
Chris Sinclair of QuarterStaff proposes:
 
Chris Sinclair of QuarterStaff proposes:
  

Latest revision as of 11:26, 19 February 2013

Get the 11th to the 20th rows of the bbc table - by population.

SELECT name, population FROM bbc
 ORDER BY population DESC LIMIT 10 OFFSET 10
SELECT TOP 10 x.name, x.population FROM (
 SELECT TOP 20 name, population FROM bbc
  ORDER BY population DESC) x
 ORDER BY x.population ASC
SELECT name, population FROM bbc
 ORDER BY population DESC LIMIT 10 OFFSET 10
SELECT name, population FROM (
 SELECT name, population, rownum n FROM (
   SELECT name,population FROM bbc
                        ORDER BY population DESC)
 )
WHERE n BETWEEN 11 AND 20
SELECT TOP 10 x.name, x.population FROM (
 SELECT TOP 20 name, population FROM bbc
  ORDER BY population DESC) x
 ORDER BY x.population ASC
SELECT * FROM bbc
 ORDER BY population DESC
 LIMIT 11, 10
Personal tools
Namespaces

Variants
Actions
Reference
Toolbox
Google AdSense