dcsimg
www.webdeveloper.com
Results 1 to 2 of 2

Thread: Grabbing Query Results where the result is comparing data within the result

  1. #1
    Join Date
    Apr 2012
    Posts
    1

    Grabbing Query Results where the result is comparing data within the result

    Hello,

    Is there a way to grab certain results from a table only when the data from the results compare to itself. For example I have table1.

    Name number1 number2 number3
    Bob 123 123 456
    Jim 123 456 789

    So what I want the query to do is to only grab results when number1 <> number2.

    So result I would be expecting is:

    Name number1 number2 number3
    Jim 123 456 789


    Would the query be as simple as

    Select * from table 1 where number1 <> number2

  2. #2
    Join Date
    Dec 2002
    Location
    St. Louis, MO, USA
    Posts
    1,582
    I believe so. Have you tried it?

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center



Recent Articles