|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Get inside! Sample the range of functionality easily built with JMSL Library for Time Series Data Analysis, Heat Maps, Portfolio Optimization, Monte Carlo Simulation, Stock Price Charting and more. Download Now! |
|
#1
January 15th, 2003, 06:25 AM
|
|||
|
|||
Beginner: 2 query's from 1 table
I have an acces database.
One table contains personal data like name, adress, tel, fax ... I need to make 2 query's. One that contains the people that live at the same adress (not the same name) and one with the people that live alone. How do i do this? i really have no idea . Pls help me. 
|
|
#2
January 16th, 2003, 09:47 AM
|
|||
|
|||
|
Code:
// for multiple select * from t where adress in (select adress from t group by adress having count(*) > 1) //for solitairies select * from t where adress in (select adress from t group by adress having count(*) = 1)
|
|
| Viewing: Dev Shed Forums > Databases > Database Management > Beginner: 2 query's from 1 table |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
