google-spreadsheet Query Function Sorting with QUERY()
Example
| A | B | C | D |
|---|---|---|---|
| 1 | pen | red | 500 |
| 2 | pen | blue | -50 |
| 3 | pen | red | 0 |
| 4 | pencil | blue | 17 |
| 5 | pencil | green | -1.5 |
To sort by column D with "order by":
=QUERY("A1:D6","select * order by D desc",1)
| A | B | C | D |
|---|---|---|---|
| 1 | pen | red | 500 |
| 2 | pen | blue | -50 |
| 3 | pen | red | 0 |
| 4 | pencil | blue | 17 |
| 5 | pencil | green | -1.5 |
To sort by column D with "order by":
=QUERY("A1:D6","select * order by D desc",1)
