Thread: What this SQL means ?

  1. #1
    Registered User
    Join Date
    Dec 2001
    Posts
    3

    Question What this SQL means ?

    See the code below:

    SELECT surname
    FROM Emps
    WHERE surname < 'DH'

    Could anyone who knows SQL please explain the meaning behind this statement --> surname < 'DH' <-- Thanx !

  2. #2
    Registered User
    Join Date
    Dec 2001
    Posts
    4
    Two words: alphabetical order

  3. #3
    Fingerstyle Guitarist taylorguitarman's Avatar
    Join Date
    Aug 2001
    Posts
    564
    it selects surname data from the Emps table that match the restriction < 'DH'

Popular pages Recent additions subscribe to a feed

Similar Threads

  1. OOP Question DB Access Wrapper Classes
    By digioz in forum C# Programming
    Replies: 2
    Last Post: 09-07-2008, 04:30 PM
  2. Please help create a loop for embedded SQL
    By cjohnman in forum C Programming
    Replies: 4
    Last Post: 04-24-2008, 06:46 AM
  3. Embedded SQL
    By sarac in forum C Programming
    Replies: 1
    Last Post: 05-04-2006, 09:09 AM
  4. Replies: 1
    Last Post: 03-21-2006, 07:52 AM
  5. Problem with embedded SQL in C/C++ (ECPG)
    By NeuralClone in forum C Programming
    Replies: 4
    Last Post: 10-21-2005, 05:16 PM