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
what are enums used for in mysql? : Sql dba
Show code of a cursor for loop.
how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba
how to fetch common records from two tables? : Sql dba
how to run 'mysql' commands from a batch file? : Sql dba
How to find 3rd highest salary of an employee from the employee table in sql?
What does partition by mean in sql?
What is not null in sql?
What is the difference between python and sql?
What are the different types of constraints?
define sql delete statement ? : Sql dba
Define join and name different types of joins?
Can we edit a view in sql?
What is a left inner join?
What is the difference between view and stored procedure?