Post reply

Select all usernames except few usernames

  • February 14, 2010 at 10:06 pm

    #210876

    Hi, i am having a table with usernames(Field is USERID), select * gives all usernames

    but i need to take that except 2 or 3 usernames, please help me on the query

    Thanks

    Jprakash

  • February 14, 2010 at 10:16 pm

    #1118659

    select * from <TABLE> where <cOLUMN> not in (nVALUES)

    kshitij kumar
    kshitij@krayknot.com
    www.krayknot.com

  • February 14, 2010 at 11:11 pm

    #1118665

    Thanks a lot kshitij kumar it worked out well, can you please help on joining the tables with two or three databases

  • February 14, 2010 at 11:36 pm

    #1118669

    jaype-365633 (2/14/2010)

    Thanks a lot kshitij kumar it worked out well, can you please help on joining the tables with two or three databases

    in LINQ or iin SQL??

    kshitij kumar
    kshitij@krayknot.com
    www.krayknot.com

  • February 15, 2010 at 1:02 am

    #1118689

    in SQL-2008, all the databases are in same server

  • February 16, 2010 at 1:51 am

    #1119108

    What is LINQ KrayKnot?

  • February 17, 2010 at 2:27 am

    #1119905

    luckysql.kinda (2/16/2010)

    What is LINQ KrayKnot?

    Click here

    Nigel
    How to post questions

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply