|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
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
September 21st, 2006, 09:28 AM
|
|||
|
|||
|
SQL question
Hi there,
I have a table with user ids and codes eg: user code use1 a use1 b use1 d use2 f use3 a use3 g What I would like to get is a result like: use1 abd use2 f use3 ag How would I write the SQL for this. At the moment I am returning every row and having to export to excel and write formulas to get the results I want. Any help will be much appreciated.
|
|
| Viewing: Dev Shed Forums > Databases > DB2 Development > SQL question |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
