SQL Query

[asif18]

A table consists of few records, given below, I have to get output in a single row.

ClassName Date Time Description
--------------- ------ ------ -----------------
K-11 10/10 08:30 Exam Hall
K-11 10/10 10:00 PGP Room
K-11 10/10 11:00 FPM Room
K-12 10/10 10:00 Audioturium


Output I should get as below using single sql command

ClassName 08:00 08:30 09:00 09:30 10:00 10:30 11:00
--------------- -------- ------- ------- ------- ------- ------- --------
K-11 08:30 10:00 11:00

Thanking you,

With Regards,
Asif

[acoder]

You've not given any information on which database you're using. I'm assuming that it's Microsoft Access which is why I've moved your thread to this forum. Technical questions do NOT belong in the Feedback forum. Please post your questions in the most appropriate forum. Your post doesn't describe what you've tried so far and what part you're stuck on. Post your attempt, so that the experts can help you resolve your problem.

Moderator.