How do i make a query for this job

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

  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