Hello,
I've got the following problem:

My table contains 5 rows including two rooms beeing booked several having different booking start time and booking finish time and date booked.

1 )Room code = AS1, start time (char) = 1800, finish time (char) = 1900, bookingDate (date) = '1-MAR-2013'
2) Room code = AS1, start time (char) = 1400, finish time (char) = 2000, bookingDate (date) = '1-MAR-2013'
3) Room code = AS1, start time (char) = 2000, finish time (char) = 2200, bookingDate (date) = '1-MAR-2013'
4) Room code = AS2, start time (char) = 1800, finish time (char) = 2100, bookingDate (date) = '1-MAR-2013'
5) Room code = AS2, start time (char) = 2200, finish time (char) = 2300, bookingDate (date) = '1-MAR-2013'

This data is wrong according to database implementation and is only inserted for producing the following query:
Basically i need to write a SQL query that will return the rooms that have overlaping booking times.
So the output must be 1 and 2 lines as their start and finish times overlap. Can anyone please tell me how this can be done?
Thanks in advance.