SQL Basic- SQL WHERE Condition


SQL WHERE Condition:


SQL WHERE Condition is used to filter records.


This condition is show only those record as per specified in where condition.


Syntax:

SELECT column_name
FROM table_name

WHERE column_name operator value;


Table:    'Student'



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

Example:


SELECT *

FROM Student

WHERE  Address ='Bareilly';






 Text Value vs. Numeric Value:

  • In SQL text values definition  requires single quotes around (most database systems will also allow double quotes).
  • Numeric value definition not required.



After executing this statement, it result is


StudentID             StudentName               Address                Country
2             Ajeet               Bareilly                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