SQL Basic- SQL DISTINCT Statement


SQL DISTINCT Statement:


This statement is used to show only DISTINCT values.



SELECT DISTINCT Statement:


In a table:


  • A column contain many duplicate value and you want only different values from table.
  • This statement retrieve only distinct(different) values.


Syntax:


SELECT DISTINCT column_name FROM table_name;



Table:    'Student'


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


Example:

SELECT DISTINCT Country 

FROM Student;




 The above SQL statement selects only distinct values from the "Country" columns from the "Student" table:


After executing this statement, it result is

Country
India


Popular posts from this blog

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

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

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