|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
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
May 18th, 2004, 08:48 AM
|
|||
|
|||
Basic SQL query logic
Hi,
I need some help on a basic SQL query. I have a table which contains emails addresses. I' like to retrieve all the emails that are repeat twice or more. Here's the SELECT statement for that table : SELECT CRIMULTI_email.strID AS strID, CRIMULTI_email.email AS Email FROM CRIMULTI_email I know it's possible to make the query in a single select statement !!! But HOW !!!! Thank you in advanced ! 
|
|
#2
May 18th, 2004, 09:09 AM
|
|||
|
|||
|
Code:
SELECT email FROM CRIMULTI_email group by email having count(*) >= 2
|
|
| Viewing: Dev Shed Forums > Databases > MS SQL Development > Basic SQL query logic |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
