0

I'm sure there is a really simple solution for this matter, but I have tried all I know without success.

I'm trying to modify this working SQL string to yield only the Top 25 results, not all results.

"SELECT * FROM" & "data.CSV" & "ORDER BY " & "Elapsed" & " DESC "*

For the Top 25 SQL syntax I have tested:

"SELECT TOP 25 FROM " & "data.CSV" & " ORDER BY " & "Elapsed" & " DESC "
"SELECT TOP 25 * FROM " & "data.CSV" & "ORDER BY " & "ELAPSED" & DESC "
"SELECT TOP 25" & " ORDER BY " & "ELAPSED" & " DESC " & FROM" & " data.CSV"

None of these three produce any results from the 45 line data file. No errors indicated, all compile.*

Any advice appreciated.

1
Contributor
1
Reply
10
Views
2 Years
Discussion Span
Last Post by Nathan1
0

Used

"SELECT TOP 25 * FROM data.CSV ORDER BY Elapsed DESC"

And randomized the test dataset for the Elapsed.

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.