Skip to main content

EXAPLES OF SQL COMMANDS

Lets start SQL commands with best and simple examples:

  • SQL Syntax:- SELECT Column-name, Column-name,......,       FROM table-name;
                               or you can use this:-
                               SELECT* FROM table-name;    
                               For Example:
                               SELECT Customer name, City FROM Customer;
     
  • SQL Syntax:-  SELECT DISTINCT Column-name, Column-name  FROM table -name;
                               For Example:
                              SELECT DISTINCT city FROM Customers;
  • SQL Syntax:- SELECT Column-name, Column-name,......,    FROM table-name;
                                WHERE Column-name,Operator value;
                                 For Example:
                                 SELECT* FROM CUSTOMERS
                                 WHERE Country ='INDIA';
Note:- * used for fetch all data, Distinct statement used to return only different values,
      



 

Comments

Post a Comment

Popular posts from this blog

How can make a comment in php?

Comments: In PHP code, Comment is a line that is not executed but it helps to other to understand what are you doing in program and why you are using the comment line or it's work as a  reminder to know what you did in the program last time.      But there is many types of comment line like single line and multi line comments:  Example for Single line comment:   <?php     echo "<p>Hello my Friends</p>";   //This is a single-line comment   echo "<p>You will be a good please read all my blogs</p>"; ?> Here is another exaple of Multiple line comment "  example : <!--          --> <?php      <!--   echo "<p>Hello my Friends</p>";     echo "<p>Hello my Friends</p>"; -->        echo "<p>Hello my Friends</p>";     echo "<p>Hello my Friend...
Post a Comment
Read more »protechnologyme

Apache Hadoop

What Is Apache Hadoop? The Apache   Hadoop project develops open-source software for reliable, scalable, distributed computing. The Apache Hadoop software library is a framework that allows for the distributed processing of large data sets across clusters of computers using simple programming models. It is designed to scale up from single servers to thousands of machines, each offering local computation and storage. Rather than rely on hardware to deliver high-availability, the library itself is designed to detect and handle failures at the application layer, so delivering a highly-available service on top of a cluster of computers, each of which may be prone to failures. The project includes these modules: ·          Hadoop Common : The common utilities that support the other Hadoop modules. ·          Hadoop Distributed File System (HDFS) : A distributed file system that provides high-thr...
Post a Comment
Read more »protechnologyme

TWO DIMENSIONAL DATA IN TABULAOR FORM

Now Friends if your concept about array is cleared  so now  we can try to excute this 2D array in tabular form , that we clearly  understand  how data stores in an array  This is very easy concept I am sharing  to understand  how can we store the data in 2D array . For example:  <html > <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <title>2D array</title> </head> <body> <?php error_reporting(0); $x=array( data_1=>array('name'=>'suraj kumar', 'dob'=> '20.10.1980', 'age'=> '30','salary'=>50000), data_2=>array('name'=>'Amit kumar', 'dob'=> '22.1.1990', 'age'=> '30','salary'=>40000), data_3=>array('name'=>'pankaj kumar', 'dob'=> '02.12.1990', 'age'=> '30','salary'=>20000), data...
Post a Comment
Read more »protechnologyme