How to check sequence number in SQL?

Hello there, I'm curious about how one might go about checking a sequence number in SQL. Could you please elaborate on the steps involved in this process? Perhaps there's a specific SQL command or function that's commonly used for this purpose? Additionally, I'm wondering if there are any common challenges or pitfalls to be aware of when working with sequence numbers in SQL. Your insights would be greatly appreciated.