SQL Basic- SQL SELECT Command


SQL SELECT Command:


This SQL statement is used to show data from database.
The result is stored in result table, called RESULT SET.


RESULT SET

A Result Set is returned to the Execute SQL task depends on the type of SQL command that the task uses. For example, a SELECT statement typically returns a result set, but an INSERT statement does not.



Syntax:


SELECT column_name 
FROM table_name;                                 //This statement returns as per defined 'column_name' in statement.


or


SELECT *
FROM table_name                                     //This statement returns all  details  from table.

Example:



Table:    'Student'


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

SELECT Column wise:


SELECT StudentID, StudentName, AddressFROM Student


After executing this statement, it result is



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

SELECT * wise:


SELECT * FROM Student


After executing this statement, it result is


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

Popular posts from this blog

Rules for Constructing Character Constants

Rules for Constructing Character Constants A character constant is a single alphabet. A single digit or a single special symbol enclosed within single inverted commas .  Both the inverted commas should point to the left. For example:                      ’A’ is a valid character constant whereas ‘A’ is not. The maximum length of a character constant can be 1 character. Ex.:  'A' 'I' '5' '='
Read more

My Bisalpur- Population

Population The city is divided into 25 wards for which elections are held every 5 years. The Bisalpur Nagar Palika Parishad has population of 73,551 of which 38,858 are males while 34,693 are females as per report released by Census India 2011. Population of Children with age of 0-6 is 10242 which is 13.93 % of total population. In Bisalpur, Female Sex Ratio is of 893 against state average of 912. Moreover Child Sex Ratio in Bisalpur is around 913 compared to Uttar Pradesh state average of 902. Literacy rate of Bisalpur city is 61.65 % lower than state average of 67.68 %. Male literacy is around 68.96 % while female literacy rate is 53.43 %. Bisalpur Religion Data 2011 Town Bisalpur Population 73,551 Hindu 53.54% Muslim   45.93% Christian 0.18% Sikh 0.01% Buddhist 0.01% Jain 0.01% Others 0.00% Not Stated 0.06% My Bisalpur Related Topic: My Bisalpur- Introdution ,   Bisalpur Population
Read more

How to bind dropdownlist inside gridview edit template

Image
Overview:   This article explains how to bind drop down list control which is placed inside Asp.net   Gridview  control under Edit Template. .i.e Gridview edit template dropdownlist bind. Also using  DataRowView  we able to get and set gridview edit template drop-down list value. On ".aspx" Page: Add gridview on design page like: On ".aspx.cs" Page: Page_load Bind gridview control: Yeah, we are done now :-) Hope you enjoyed this tutorial. If you have any recommendations, please let us know what you think in the comment section below! See you again next time!
Read more