What is the use of OFFSET command?

With coding example