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 a schema? How is it useful in sql servers?
How many parts of a pl sql block are optional?
What is the difference between null value, zero, and blank space?
What are the different types of sql commands?
Are stored procedures faster than queries?
What are packages in pl sql and also explain its advantages?
Is inner join faster than left join?
What are the different schemas objects that can be created using pl/sql?
Is like operator in sql case sensitive?
How to process query result in pl/sql?
Is hadoop a nosql?
What are the uses of merge?
does sql support programming? : Sql dba
What is full form of rtm?
How many functions are there in sql?
