How can i do this ?

Discussion in 'Databases' started by suzana, Mar 6, 2008.

0
  1. #1
    i want a unique of the first column and one second column how can i do that using sql

    "select distinct row1 , rows2 from table " gives error :(

    row1 , rows2 , rowid

    Abi-Titmuss Abi-Titmuss-1.JPG 10
    Abi-Titmuss Abi-Titmuss-10.JPG 11
    Abi-Titmuss Abi-Titmuss-11.JPG 12
    Abi-Titmuss Abi-Titmuss-12.JPG 13
    Ada-Nicodemou Ada-Nicodemou-1.JPG 49
    Ada-Nicodemou Ada-Nicodemou-10.JPG 50
    Ada-Nicodemou Ada-Nicodemou-11.JPG 51
    Ada-Nicodemou Ada-Nicodemou-12.JPG 52
    Ada-Nicodemou Ada-Nicodemou-2.JPG 53
    Ada-Nicodemou Ada-Nicodemou-7.JPG 58
    Ada-Nicodemou Ada-Nicodemou-8.JPG 59
    Ada-Nicodemou Ada-Nicodemou-9.JPG 60
    Adele-Silva Adele-Silva-1.JPG 61
    Adele-Silva Adele-Silva-2.JPG 62
    Adele-Silva Adele-Silva-3.JPG 63
    Adele-Silva Adele-Silva-4.JPG 64
    Adele-Silva Adele-Silva-5.JPG 65
    Adriana-Karembeu Adriana-Karembeu-1.JPG 66
    Adriana-Karembeu Adriana-Karembeu-10.JPG 67
    Adriana-Karembeu Adriana-Karembeu-11.JPG 68
    Adriana-Karembeu Adriana-Karembeu-12.JPG 69
     
    suzana, Mar 6, 2008 IP
  2. nebhotep

    nebhotep Active Member

    Messages:
    244
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    80
    #2
    Select row1 , rows2 from table
    group by row1,row2
     
    nebhotep, Mar 6, 2008 IP