Hi everyone
  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,
Pradeep

Prad,
First you need to learn the SQL syntax for selecting rows in a table.
In your example assuming your first field in your table is the row number named Id.

The syntax will be:

SELECT * FROM tablename WHERE Id = 81;

Get the MySQL Beginner's book from WROX it is more than it's worth.
And your gained knowlege will be for life.