SQLTeam.com | Weblogs | Forums

Select data in one column



i want to select to display all data in one column.
how to do that?
all below under status column.
select 'Redeemed', 'Expired', 'Unredeemed'`


select column from yourtable


Please post create table script and inserts with sample data, what queries you've tried and desired output for inserted sample data.


is ok, i get it done by myself. thanks.

select 'Redeemed' as status union select 'Expired'as status union select 'Unredeemed' as status


I don't suppose it matter for a small data set like that, but UNION ALL would be better if you KNOW that there are no duplicates (UNION will remove any duplicates, and that takes a some processing power to do, of course)