rajasimha.sallagundla

Navigator | Tier 3

Question

About excel as a database queries

Forum|Forum|4 years ago
March 9, 2022
6 replies
101 views

I have one excel file in that I need to get top5 highest values (based on column vaues)into one sheet and top5 lowest values in to one sheet(I need all columns)? Tell me how to write sql query for this. FYI attaching the excel file.(based on CHNG column need to get this top 5 highest and top 5lowest)

Navigator | Tier 3

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

Blogs at TheCodingTheory - https://www.thecodingtheory.com

rajasimha.sallagundlaAuthor

Navigator | Tier 3

Hi Ashwin,

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

Navigator | Tier 3

Try:

SELECT TOP 5 * FROM [Sheet1$$]

ORDER BY CDbl([CHNG]) DESC;

rajasimha.sallagundlaAuthor

Navigator | Tier 3

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

rajasimha.sallagundlaAuthor

Navigator | Tier 3

No it's not working.

Navigator | Tier 3

You could use:

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