have a urgent requirement. Please somebody help me.
I have a table departinfo with following records
begin_time end_time Name Pieces
10:00 10:15 PopCorn 3
10:15 10:30 Biscuits 5
10:30 10:45 PopCorn 2
Now I need to run a sql query and the output should be as below :
begin_time end_time PopCorn Biscuits
10:00 10:15 3 0
10:15 10:30 0 5
10:30 10:45 2 0
Please note that only one column i.e. PopCorn is created in spite of
having multiple records in the table. Similarly the records are not
fixed. I mean that
there can be n number of records and the columns should be uniquely
created.
Can somebody help me out
PLZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZ ZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZ ZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZ