February 7th, 2013, 04:10 AM
|
|
Registered User
|
|
Join Date: Feb 2013
Posts: 1
Time spent in forums: 3 m 53 sec
Reputation Power: 0
|
|
|
Combine Multiple Rows Into Single Rows
PHP Code:
Hi,
I have a table with the following data:
TABLE -X
RNO FROM_SQN TO_SQN DATE
================================================== ==
991 9 11 2010-01-01
991 11 22 2010-01-01
991 22 33 2010-01-01
992 33 44 2010-01-01
I want to see the result data as follows:
RNO FROM_SQN TO_SQN DATE
================================================== =======
991 9 44 2010-01-01
Please help me how to achieve this using SQL.
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
