1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

How do i make a query for this job

Discussion in 'Databases' started by mani, Dec 4, 2006.

0
  1. #1
    Hello every one,
    I want to make a query to select some data please guide me

    Suppose i have data in table1 as followed

    ID NAME
    1 Imran
    2 Hassan
    3 Imran
    4 Ahmer
    5 Hamid
    6 Imran


    Now i want to select all of the records but with no dupplication, such that i could have all the name records but imran should be only once, as it is repeated 3 times in table1.

    Please write some query for this

    thanks
     
    mani, Dec 4, 2006 IP
  2. T0PS3O

    T0PS3O Feel Good PLC

    Messages:
    13,219
    Likes Received:
    777
    Best Answers:
    0
    Trophy Points:
    0
    #2
    SELECT DISTINCT(name) WHERE 1
     
    T0PS3O, Dec 4, 2006 IP
  3. mani

    mani Peon

    Messages:
    679
    Likes Received:
    16
    Best Answers:
    0
    Trophy Points:
    0
    #3
    thanks man it works,

    one more thing, how do i export the access(mdb) data as sql dump file?
     
    mani, Dec 4, 2006 IP