What this SQL means ?

This is a discussion on What this SQL means ? within the C++ Programming forums, part of the General Programming Boards category; See the code below: SELECT surname FROM Emps WHERE surname < 'DH' Could anyone who knows SQL please explain the ...

  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, 05:30 PM
  2. Please help create a loop for embedded SQL
    By cjohnman in forum C Programming
    Replies: 4
    Last Post: 04-24-2008, 07:46 AM
  3. Embedded SQL
    By sarac in forum C Programming
    Replies: 1
    Last Post: 05-04-2006, 10: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, 06:16 PM

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21