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