SELECT ROWNUMBER() OVER() AS rowno, author FROM books;