ORDER BY and DISTINCT tutorial in php

 SELECT with ORDER BY Syntax :

SELECT column1, column2, column3... FROM table_name ORDER  BY column1, column2, column3...ASC | DESC;


If we want to arrange all records names in Ascending Order from table name "personal" then we can use ORDER BY as shown below sql query :

SELECT * FROM personal ORDER BY name;


If we want to arrange all records names in Descending Order from table name "personal" then we can use ORDER BY as shown below sql query :

SELECT * FROM personal ORDER BY name DESC;


If we want to select records in Descending Order and city must be "Agra" (with condition) then we can use ORDER BY as shown below sql query :

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

For arrange Ascending order to above records, then we can use below query :

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


If we want to arrange records in Ascending Order depending upon Age from table name "personal" using ORDER BY then we can use below sql query :

SELECT * FROM personal ORDER BY age;


If we want to arrange records in Ascending Order depending upon city Names from table name "personal" using ORDER BY then we can use below sql query :

SELECT * FROM personal ORDER BY city;


If we want to Ascending Order to multiple Columns from table name "personal" using ORDER BY as shown below sql query :

SELECT * FROM personal ORDER BY name, city;


SELECT Data with DISTINCT :

SELECT DISTINCT column1, column2,... FROM table_name;


If we want to select city names from records with DISTINCT value from table name "personal" using DISTINCT then we can use below sql query :

SELECT DISTINCT city FROM personal;


If we want to select age from records with DISTINCT value with ASCENDING ORDER from table name "personal" using DISTINCT and ORDER BY then we can use  below sql query :

SELECT DISTINCT age FROM personal ORDER BY age;


MAIN USE OF "DISTINCT" IS FOR GIVING UNIQUE DATA BY REMOVING DUPLICACY AND "ORDER BY" IS FOR ARRANGING COLUMN DATA IN ASCENDING ORDER AND DESCENDING ORDER.


Comments

Post a Comment

Popular posts from this blog

Logical_Operators

  <?php     $age = 20 ;     $age1 = 25 ;     if ( $age >= 18 && $age <= 21 )     {         echo "You are Eligible<br>" ;     }         if ( $age >= 18 || $age <= 21 )     {         echo "You are Eligible<br>" ;     }     //Below condition is True So that "Not Operator(!)" will return False condition     if (!( $age >= 18 ))     {         echo "You are Eligible<br>" ;     }     //Below condition is False So that "Not Operator(!)" will return True condition     if (!( $age <= 18 ))     {         echo "You are Eligible<br>" ;     }     //If both condition is "True" OR "False" at that time xor will return "False" and if one condition is     //"True" and s...
Read more

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

Get Functions

  <?php //There are many Get Functions in PHP as shown below: //get_class, get_parent_class, get_class_methods, get_class_vars, get_object_vars, get_called_class, //get_declared_classes, get_declared_interfaces, get_declared_traits, class_alias class ParentClass {     function name ()     {         echo "Class Name : " . get_class ( $this ) . "<br>" ;   //Print the particualr Class Name         //Print the particular Parent Class Name as shown below:         echo "Parent Class Name : " . get_parent_class ( $this ) . "<br>" ;     } } class ChildClass extends ParentClass {     function __construct ()     {}     function myfunction ()     {}     function myfunction2 ()     {} } $obj = new ChildClass (); $obj -> name (); echo "Class Name is : " . get_class ( $obj ) . "<br>" ; echo "Paren...
Read more