how to retrive only second row from table?

Answer Posted / m

IN Mysql we can do like this,
in that number starts from 0 so first parameter show
after LIMIT is row no. means here second row
and next 1 for limit that how many records do u want
to show. it means 1 record.


SELECT *
FROM `student_info`
LIMIT 1 , 1;

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what are enums used for in mysql? : Sql dba

585


Show code of a cursor for loop.

555


how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba

605


how to fetch common records from two tables? : Sql dba

599


how to run 'mysql' commands from a batch file? : Sql dba

595






How to find 3rd highest salary of an employee from the employee table in sql?

540


What does partition by mean in sql?

493


What is not null in sql?

546


What is the difference between python and sql?

501


What are the different types of constraints?

542


define sql delete statement ? : Sql dba

522


Define join and name different types of joins?

492


Can we edit a view in sql?

521


What is a left inner join?

513


What is the difference between view and stored procedure?

468