Before asking this question I looked here and did not find the same problem. I use the Google Spreadsheet as my Database and use the sheetrock + sql library to access the spreadsheet. I can return the data but something happens in particular.
I have the following records in the table:
id Ano mês Data 1448 2018 maio 24/05/2018 1449 2018 maio 29/05/2018 1450 2018 maio 29/05/2018 1451 2018 maio 29/05/2018 1452 2018 maio 29/05/2018 1453 2018 junho 05/06/2018 1454 2018 junho 05/06/2018 1455 2018 junho 05/06/2018 1456 2018 junho 05/06/2018 1457 2018 junho 05/06/2018
I need all records of current month (eg June) and current year (ex: 2018). I use the following SQL
var sqla = 'select * where B = "' + [variável que pega o ano] + '"' + ' and E = "' + [variável que pega o mês] + '" order by A DESC ' ;
But when I use order by A DESC it does not return the last record with id 1457 . If you remove the Order by it returns all the records. But, I need you to return the data in descending order.
What can be my mistake ?? Can anyone help me?