SQL Basic- SQL Syntax


          SQL Syntax:           






SQL Syntax

Database Tables

A database contains one or more tables. Each table is identified by a name (e.g. "Student" or "Product"). 

Tables contain records (rows) with data.

Below is a selection from the "Student" table:


StudentID             StudentName               Address                Country
1             Ajay               Noida                India
2             Ajeet               Bareilly                India
3             Shivam               Nagaland                India

The table above contains three records (one for each student) and four columns (StudentID, StudentName, Address, Country).



SQL Statements

Most of the actions you need to perform on a database are done with SQL statements.The following SQL statement selects all the records in the "Student" table:

Exmaple:

              SELECT * FROM Student         
After executing this statement, You see result as follows:

StudentID            StudentName              Address               Country
1            Ajay              Noida               India
2            Ajeet              Bareilly               India
3            Shivam              Nagaland               India

Popular posts from this blog

C# Fundamental: Data Types and Variable

Image
Data Types In C#, data types are used to store values in the memory. When data type is declared, it allocates a block of memory to hold the value. All the data types are directly or indirectly derived from the  System.object  class. Before moving, we need to understand the variables. Variables A variable is used to store the value (data). It is an address given to a memory location. Example: Take an example of a bag here bag is a variable we can put books into a bag and we can take them out again but we can put books according to bag size, a bigger bag can hold more books. Similarly, we can store and retrieve data from a variable. Here bag is the variable name the size of bag is the data type, an  int  can hold 32 bit value and  long  can hold 64 bit value. Different data types have different sizes we use them according to our requirement for example if we want to store only two values  true  or  false  we...
Read more

Type Declaration Instruction in C

Type Declaration Instruction This instruction is used to declare the type of variables being used in the program. Any variable used in the program must be declared before using it in any statement. The type declaration statement is written at the beginning of main( ) function. Ex.: int bas ; float rs, grosssal ; char name, code ; There are several subtle variations of the type declaration instruction. These are discussed below: While declaring the type of variable we can also initialize it as shown below. int i = 10, j = 25 ; float a = 1.5, b = 1.99 + 2.4 * 1.44 ; The order in which we define the variables is sometimes important sometimes not. For example, int i = 10, j = 25 ; is same as int j = 25, j = 10 ; However, float a = 1.5, b = a + 3.1 ; is alright, but float b = a + 3.1, a = 1.5 ;         is not. This is because here we are trying to use a even before defining it. The following statements would work int a, b, c, d ; a = b = ...
Read more