Combine two rows in one table to single row using SQL

ebine rose

Rate me:

5.00/5 (1 vote)

31 Dec 2012CPOL

39.7K

ID Name Address Acc_Number BookingNo Amt 1 MERY Kollam 111111111 NULL 1000 2 Jos Kochi 111111111 c/01 NULLDesired Output ID Name Address Acc_Number BookingNo Amt 1 MERY Kollam 111111111 c/01 1000Please helpThanks in advance....

Alternatives

Members may post updates or alternatives to this current article in order to show different approaches or add new features.

1. Combine two rows in one table to single row using SQL

31 Dec 2012prashant patil 4987

refer below links:Hope it will help you;Link 1[^]Link 2[^]Link 3[^]

ASP.NET2

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Written By

ebine rose

India

This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

Combine two rows in one table to single row using SQL

Alternatives

License

Comments and Discussions