How do I reorder a table using Google query language?

0

Good afternoon.

I’m trying to analyse some data in a Google spreadsheet using the query language, but I’ve hit a brickwall and hope someone can help.

Here’s the data: https://spreadsheets.google.com/ccc?key=0ApL1zT2P00q5dE1tQVhLcHdiZ1hQRXBvc0tFdFV1Zmc&hl=en_GB&authkey=CISto5cD

I’ve created a query that allows me to create a table listing the number of crimes in a local neighbourhood in ascending order, thus

https://spreadsheets.google.com/tq?tqx=out:html&tq=select C, D order by D&key=tMmAXKpwbgXPEposKEtUufg&hl=en_GB#gid=1

All I want to do is reorder the table so that the highest are listed first.

Can anyone help?

Tags: asked February 7, 2011

Leave a Reply

2 Answers

1

"select C, D order by D asc" for ascending "select C, D order by D desc" for descending

but you should encode it to make it work: http://code.google.com/apis/chart/interactive/docs/querylanguage.html#Setting_the_Query_in_the_Data_Source_URL

justin
10

Leave a Reply

10
0

All you need to do is add the phrase desc, as in mysql queries

Leave a Reply

5
0

Fourth, the payments are optional, pay pal, credit card, western union and money gram will be offered soon.

Leave a Reply

0

Your Answer

Please login to post questions.