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 is the purpose of the primary key?
How do I start pl sql?
explain advantages of myisam over innodb? : Sql dba
Explian rowid, rownum?
Do ddl statements need commit?
what are date and time data types in mysql? : Sql dba
How is indexing done in search engines?
Which is faster union or join?
What is the best sql course?
What is normalization in a database?
How can we optimize a sql query?
What are operators available in sql?
What is a temporal table?
Differentiate pl/sql and sql?
What is multiple columns?