Select statement for sql server

Question

Hello I need to get two types of values from a column, the statement should display as follow,

Select bid-id 
from bid 
where status = 'Expired' 

as Successful and

Select bid-id 
from bid 
where status ='Unsold' 

as Failed, each one ordered by datename(mm, date).

Can someone help me how to make these two statements run in one same statement please?

Answer 1

Try this:

SELECT
[bid-id],
CASE WHEN Status = 'Expired' THEN
    'Successful'
WHEN Status = 'Unsold' THEN
    'Failed'
END AS [Status]
FROM
    [bid]
ORDER BY datename(mm, date)

If you need values in separate columns, use this:

SELECT
(SELECT [Bid-id] FROM [bid] WHERE Status = 'Expired' ORDER BY datename(mm, date)) AS [Successful],
(SELECT [Bid-id] FROM [bid] WHERE Status = 'Unsold' ORDER BY datename(mm, date)) AS [Failed]
FROM
[Bid]