Question

Write a query to display unique student ID who joined in the month of June. Sort the result in ascending order.

Answer 1

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....