Write a query to display unique student ID who joined in the month of June. Sort the result in ascending order.
Answers
Answered by
0
Answer:
I assume that you are running Oracle, as the use of to_char() suggests.
If you want students that joined in june of a given year, say 2019, then I would recommend to check doj against a half-open interval (this is more efficient than applying a date function on the column):
hope it help you....
Similar questions