Query

Query:-

Connect Structure

Click on SQL icon for Query Execution.

! (Execute Symbol) - For Execute Query

• HOW TO WRITE QUERY:

  1. Select - Select * from Student(table name);
  
  
  
   *  =  All Records
  
  CLAUSES
  1. Where
  2. Order
  3. Between
  
  ex.
  1. Between clause (age from 18 to 21)
  Select * from student where ( age between 18 and 21);
  
  
  
  
  2. Order (Alphabetical order by default)
  Select * from student order by name;
  
  
  
  
  3. Ascending
  Select * from student order by name ASC;
  
  
  
  4. Descending

          Select * from student order by name DESC;

 

        

         5. GROUP BY NAME

         Select * from student GROUP BY NAME;