To retrieve a row by giving row number
I'm new to MySQL, Is there any query in MySQL than can display a single row when given its row number. for example there are 100 rows , when given the row number as 81 , it has to display all the records in the 81 row. I'm using the query given below. but its not working.
"SELECT ROW_NUMBER() OVER (ORDER BY id ASC) AS rn, * from myTable where rn = " + rowNo + " ORDER BY columnName"
Someone please help me,
Thanks in advance,