About excel as a database queries

Hi @RAJASIMHA SALLAGUNDLA​ ,

Could you check if this logic provides the expected output?

SELECT TOP 5 * FROM [Sheet1$$]

ORDER BY [CHNG] DESC;

Kind Regards,

Ashwin A.K

Hi Ashwin,

I tried same logic,its giving result but not giving highest CHNG values in descending order. But its giving random values.

Try:

SELECT TOP 5 * FROM [Sheet1$$]

ORDER BY CDbl([CHNG]) DESC;

Hi Aswin, instead of excel as database , using loops and if conditions how we gonna get this..​

No it's not working.​

You could use:

• SELECT * FROM [Sheet1$$] ORDER BY CHNG DESC LIMIT 5
• SELECT * FROM [Sheet1$$] ORDER BY CHNG ASC LIMIT 5