Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Channel | Week | Date | Start Time | End Time | Description |
CAT1 | 21 | 5/23/2015 | 2:00:00 | 2:11:34 | A |
CAT1 | 21 | 5/23/2015 | 2:00:00 | 2:25:39 | A |
CAT1 | 21 | 5/23/2015 | 2:14:49 | 2:19:58 | A |
CAT1 | 21 | 5/23/2015 | 2:23:08 | 2:25:39 | A |
CAT1 | 21 | 5/23/2015 | 2:25:39 | 2:39:58 | B |
CAT1 | 21 | 5/23/2015 | 2:25:39 | 2:55:54 | B |
CAT1 | 21 | 5/23/2015 | 2:43:43 | 2:47:03 | B |
CAT1 | 21 | 5/23/2015 | 2:51:02 | 2:55:54 | B |
CAT1 | 21 | 5/23/2015 | 2:57:54 | 3:12:08 | C |
CAT1 | 21 | 5/23/2015 | 2:57:54 | 3:27:49 | C |
CAT1 | 21 | 5/23/2015 | 3:15:53 | 3:19:23 | C |
CAT1 | 21 | 5/23/2015 | 3:23:03 | 3:27:49 | C |
CAT1 | 21 | 5/23/2015 | 3:27:49 | 3:34:35 | D |
CAT1 | 21 | 5/23/2015 | 3:27:49 | 3:57:39 | D |
CAT1 | 21 | 5/23/2015 | 3:38:20 | 3:44:49 | D |
CAT1 | 21 | 5/23/2015 | 3:48:29 | 3:57:39 | D |
CAT1 | 21 | 5/23/2015 | 3:59:39 | 4:05:58 | E |
CAT1 | 21 | 5/23/2015 | 3:59:39 | 4:28:53 | E |
CAT1 | 21 | 5/23/2015 | 4:09:23 | 4:15:12 | E |
CAT1 | 21 | 5/23/2015 | 4:18:32 | 4:28:53 | E |
I have a above data where i want only second field of a particular 'description'. how will i be able to fetch only that part of data..??
Create a new table and drop the original:
New:
LOAD * WHERE Counter =2;
LOAD
Channel,
Week,
Date,
[Start Time],
[End Time],
Description,
autonumber([End Time], Description) as Counter
FROM
Old
Order By
Channel,
Week,
Description,
Date,
[Start Time],
[End Time]
;
Drop Table Old;