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 the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba
what is a constraint? Tell me about its various levels. : Sql dba
What is the unique index?
What is basic structure of pl sql?
What is sql prepared statement?
how to use like conditions? : Sql dba
What are inner and outer joins examples of both?
What do you think about pl/sql?
What is sql architecture?
What are aggregate functions in sql?
What is query execution plan in sql?
What are basic techniques of indexing?
What is the difference between distinct and unique in sql?
What are the key differences between SQL and PL SQL?
How many types of triggers are there in pl sql?