better SQL syntax to find the latest data of different symbols? #3973
Closed
sevenjay
started this conversation in
Show and tell
Replies: 1 comment
-
I get this, thanks for all. |
Beta Was this translation helpful? Give feedback.
0 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
To find the latest one data of different symbols
Is there better SQL syntax? I use below
It is necessary to number each row and then take the row numbered 1, which may not be efficient.
The structure of the table is as follows:
Using the above SQL syntax to query this table, we will get the following Result:
Beta Was this translation helpful? Give feedback.
All reactions