LIMIT and OFFSET tutorial in php

SELECT with LIMIT Syntax :

 SELECT column1, column2, column3...FROM table_name WHERE condition LIMIT number;


If we want to select Limited number of records then we can use LIMIT from table name "personal" as shown below sql query :

SELECT * FROM personal LIMIT 5;


If we want to select Limited number of records with any specific condition like city = "Agra" using LIMIT from table name "personal" as shown below sql query :

SELECT * FROM personal WHERE city = "Agra" LIMIT 7;

We can order in Ascending Order to above records using ORDER BY from table name "personal" as shown below sql query :

SELECT * FROM personal WHERE city = "Agra" LIMIT 7 ORDER BY name;


SELECT with OFFSET Syntax :

SELECT column1, column2, column3...FROM table_name WHERE condition LIMIT offset, number;


If we want to select particular number of records and select from any particular index of records from table name "personal" then we can use OFFSET as shown below sql query :

SELECT * FROM personal LIMIT 3, 3;

Here above First 3 means From which index the records will be select and second another 3 means number of records to select.

Comments

Post a Comment

Popular posts from this blog

SubQuery with EXISTS and NOT EXISTS in PHP

 SELECT with SubQuery Syntax : SELECT columns FROM table1 WHERE column = (SELECT columns FROM table2 WHERE condition); In "personal" table, there are 6 columns named id, name, percentage, age, gender, city. In "personal" table, column name "id" is PRIMARY KEY and column name "city" is FOREIGN KEY. In "courses" table, there are 2 columns named course_id and course_name. In "courses" table, column name "course_id" is PRIMARY KEY. In "city" table, there are 2 columns named cid and cityname. In "city" table, column name "cid" is PRIMARY KEY. If we want to select records from "personal" table who belong to Delhi from "city" table using SubQuery then we can use below shown sql query : SELECT name FROM personal WHERE city = (SELECT cid FROM city WHERE cityname = "Delhi"); If we want to select records from "personal" table who belong to Delhi and Agra from...
Read more

UNION and UNION ALL in PHP

 In "personal" table, there are 6 columns named id, name, percentage, age, gender, city. In "personal" table, column name "id" is PRIMARY KEY and column name "city" is FOREIGN KEY. In "courses" table, there are 2 columns named course_id and course_name. In "courses" table, column name "course_id" is PRIMARY KEY. In "city" table, there are 2 columns named cid and cityname. In "city" table, column name "cid" is PRIMARY KEY. In "lecturers" table, there are 6 columns named id, name, percentage, age, gender, id_of_personal. In "lecturers" table, column name "id" is PRIMARY KEY and column name "id_of_personal" is FOREIGN KEY. UNION and UNION ALL Syntax : SELECT column1, column2 FROM table1 UNION/UNION ALL SELECT column1, column2 FROM table2; RULES : 1) Each SELECT statement within UNION must have the same number of columns. 2) The columns must also have ...
Read more

Classes and Objects in PHP OOPS

<?php class TV {     public $model = "xyz" ;     public $volume = 1 ;         //By default functions are public unless you define private or protected.     public function volumeUp ()     {         $this -> volume ++;     }     public function volumeDown ()     {         $this -> volume --;     } } $tv_one = new TV (); $tv_two = new TV (); echo $tv_one -> volume . "<br>" ; echo $tv_two -> volume . "<br>" ; echo $tv_one -> model . "<br>" ; echo $tv_two -> model . "<br>" ; $tv_one -> volumeUp (); echo $tv_one -> volume . "<br>" ; $tv_one -> volumeDown (); echo $tv_one -> volume . "<br>" ; // OUTPUT : //1 // 1 // xyz // xyz // 2 // 1 ? >
Read more