Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Display Duplicate Record into Single Record

Author  Topic 

bullfreak
Starting Member

1 Post

Posted - 2008-09-02 : 22:02:39
I have a table like this
using select all output is :

ID Price Qty
A 2 2
A 3 12
A 4 32
B 5 2
B 3 2
B 1 4


How to display like this using SQL :

ID Price Qty
A 2 2
3 12
4 32
B 5 2
3 2
1 4






Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2008-09-02 : 22:05:07
That is a job for the front end application or report writer that you are using to display the data.




CODO ERGO SUM
Go to Top of Page
   

- Advertisement -