Display data - problem
Display data - problem
(OP)
Hello
I am currently doing a small project and here is my table -
USER_ID TIME_START TIME_END NAME
1 1 2 MAX
2 3 7 MAX
3 5 6 PEPPER
4 1 7 SUE
Let say I want to know who is available between 4 and 5. Of course I know Pepper will be free at that time. I know max in the second row will not displayed as 4 and 5 are in the way but Max in the first row will be displayed. So I need to know how to automatically discard the same name out when carrying out the logical operations.
I would be very very grateful if you give me tip or help
Maverickmax77
I am currently doing a small project and here is my table -
USER_ID TIME_START TIME_END NAME
1 1 2 MAX
2 3 7 MAX
3 5 6 PEPPER
4 1 7 SUE
Let say I want to know who is available between 4 and 5. Of course I know Pepper will be free at that time. I know max in the second row will not displayed as 4 and 5 are in the way but Max in the first row will be displayed. So I need to know how to automatically discard the same name out when carrying out the logical operations.
I would be very very grateful if you give me tip or help
Maverickmax77





RE: Display data - problem
select name from <table> where ('04:00:00' between time_start and time_max) and ('05:00:00' between time_start and time_max)
Obs: time_start and time_max are defined as "time type" and the representation is "hh:mm:ss"