WHERE (establishing criteria in SQL)

Posted by Elisha Database on 01 11th, 2009 | 9 responses

For many of the SQL instructions that tell use some criteria will be essential to identify which records will be involved in such instruction, for example, if I select a telephone listing of the schedule table may not want to show all contacts, but only those who living in Buenos Aires. This should tell you a standard cone using the WHERE clause shown below: 

 SELECT surname, name, phone FROM book WHERE Province = 'Buenos Aires'

Then show several examples that show the possible options.
All contacts who live in Buenos Aires and well over 21 years: 

 SELECT surname, name, phone FROM book WHERE Province = 'Buenos Aires' AND age> 21

All women between 20 and 27 years: 

 SELECT surname, name, phone FROM book WHERE Sex = 'F' AND Age> = 20 AND age <= 27

All contacts who live in Ituzaingó or moron.
It is important to note that no contact can live in Ituzaingó and Moron. Live in or live in Ituzaingó moron so you must use the OR keyword to combine the two criteria. 

 SELECT surname, name, phone FROM book WHERE location = 'Ituzaingó' OR city = 'Moron'

9 Responses to "WHERE (establishing criteria in SQL)"

  1. Connect to Microsoft Access database and Fill DataGridView | Only vb.net says:
    03/02/2009 at 8:52 pm

    [...] Should be used (cnn). If you want to select only certain records need to add a WHERE condition to the instructions of [...]

    Answer
  2. Connect to SQL Server database and Fill DataGridView | Only vb.net says:
    03/02/2009 at 8:52 pm

    [...] Should be used (cnn). If you want to select only certain records need to add a WHERE condition to the instructions of [...]

    Answer
  3. A | vb.net only says:
    11/02/2009 at 5:45 pm

    [...] Particular instance of source code. See also: GROUP, HAVING, ISA, REFERENCES OF, SELECT, WHERE, [...]

    Answer
  4. berkah says:
    29/03/2009 at 12:55 am

    WHERE menggunakan bagaimana dengan dua kondisi nya g objek STRING

    Answer
  5. berkah says:
    29/03/2009 at 12:57 am

    AND operator dengan ... s menggunakan listview

    Answer
  6. Elisha says:
    29/03/2009 at 1:01 am

    Jika saya dengan tidak mengerti pertanyaan Benar Go, Go Kirim tapi saya akan bahwa untuk Haruz Dalam batch data string kutip tunggal ('). Misalnya: WHERE nama = 'Jack'

    Answer
  7. Connect to SQL Server database and Fill DataGridView «Database and Web Technology says:
    08/06/2009 at 11:26 pm

    [...] Should be used (cnn). If you want to select only certain records need to add a WHERE condition to the instructions of [...]

    Answer
  8. cancuneitor says:
    24/06/2009 at 4:29 am

    and do not understand the comments.

    This brilliant that they fill the fields alone, put them with crackers (cokies)?

    Answer
  9. th3r0rn says:
    25/07/2011 at 12:11 p.m.

    This is super basic, and for the age between 20 and 27 years can use beetwen.
    Regards

    Answer

Comment