Problems in Sql using Google Api

2

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?

    
asked by anonymous 06.06.2018 / 16:00

0 answers