Ok, say you wanted to select all the types of birds in the show who are over 17 feet tall. The Select statement would be something like:
Where Birds is the table which contains details of the birds. Although the above statement would select the same type twice, so if we add the Distinct command into the above statement this will only return one entry for the type of bird, even if there are many birds of that type over 17 feet:Code:SELECT Birds.Type FROM Birds WHERE Birds.Height > 17
You could search for all all birds with the name Henry:Code:SELECT DISTINCT Birds.Type FROM Birds WHERE Birds.Height > 17
Does this answer your question, or are you confused, I know I amCode:SELECT * FROM Birds WHERE Name = 'Henry'
![]()





Reply With Quote