How do I reorder a table using Google query language?
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?
2 Answers
"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
Leave a Reply
You must be logged in to post a comment.
All you need to do is add the phrase desc, as in mysql queries
Leave a Reply
You must be logged in to post a comment.
Fourth, the payments are optional, pay pal, credit card, western union and money gram will be offered soon.
Leave a Reply
You must be logged in to post a comment.
Your Answer
Please login to post questions.