sql logic and code question

nemrut · #1 (**permalink**) 07-05-10, 05:34

here(image link) how my table is going to look like;

db screenshot on Flickr - Photo Sharing!

supposing i want to print a message tells who live in the same home

if their street and door numbers are the same.

ex:

ahmet,hakan,kaan(name) live at the same home
irem,semih live at the same home

how can i figure out the sql code here?
thx for your answers!

r937 · #2 (**permalink**) 07-05-10, 05:53

Code:

SELECT t.name
     , t.surname
     , t.street
     , t.door
  FROM ( SELECT street
              , door
           FROM daTable
         GROUP
             BY street
              , door
         HAVING COUNT(*) > 1 ) AS d
INNER
  JOIN daTable AS t
    ON t.street = d.street
   AND t.door   = d.door

nemrut · #3 (**permalink**) 07-06-10, 13:46

thank you very much. it works fine.

can we add an "id " cloumn which has same id inputs for same "street and door" s? so that i can say same id's live at same place.

it's ok if you suggest another way, thx again

Internet Services

Web Development

Digital Marketing

Consumer Tech