how to get multiple rows result in a single row
Posted on 2011-10-28
I have table which has two columns one RecordTypeID and second is Price.
RecordTypeID column is uses to store multiple types of records in this single table
RecordType can – Pending = 1
Closed = 2
Listings = 3
Right now, if I run this sql
Select Price from PropertyProfit Where RecordTypeID (1,2,3)
I get 3 rows.
Now, I need to write an sql query which can return in format and in a single row.
Pending Closed Listings
1 2 3
Can any one help me out here