how can i retrieve same column with two different alias?
I have one table called 'answers' with four column wherein adding answers
with positive and negative rankings and i want to retrieve answer with
different aliasing for answer with positive ranks and answer with negative
ranks. is there any way to retrieve same column with two different aliases
?
id answer rank question_id
1 Yes 1 1
2 No 2 1
3 True -2 2
4 False -1 2
No comments:
Post a Comment