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
Explain architecture of sql server notification services?
Why functions are used in sql?
What is materialized view in sql?
How you can copy a file to file content and file to pl/sql table in advance pl/sql?
What are different types of queries in sql?
how to calculate the difference between two dates? : Sql dba
how to use case expression? : Sql dba
What is input buffer in sql*plus?
What is the benefit of foreign key?
Explain foreign key in sql?
How do I save the results of sql query in a file?
What is difference between left and right outer join?
what is a record in a database ? : Sql dba
What is query syntax?
what is union? : Sql dba