Skip to content

Instantly share code, notes, and snippets.

/gist:1033391

Created June 18, 2011 18:45
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save anonymous/1033391 to your computer and use it in GitHub Desktop.
Save anonymous/1033391 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
select playlog_id,broadcastdate,broadcasttime,delay,filename,reference,referencetime from playlogs
group by playlog_id,broadcastdate,broadcasttime,delay,filename,reference,referencetime
order by playlog_id,broadcastdate,broadcasttime,delay,filename,reference,referencetime;
1 22-04-2011 06:14:04:06 [null] asrun_22-04-2011.txt plansza-emisja 01:00:00:00
2 22-04-2011 07:14:04:06 [null] asrun_22-04-2011.txt plansza-emisja 01:00:00:00
3 22-04-2011 08:00:00:06 [null] asrun_22-04-2011.txt jingiel-emisja 00:00:05:00
4 22-04-2011 08:02:00:06 [null] asrun_22-04-2011.txt jingiel-emisja 00:00:05:00
5 22-04-2011 20:15:49:08 [null] asrun_22-04-2011.txt plansza1-emisja 01:00:00:00
6 22-04-2011 21:15:49:08 [null] asrun_22-04-2011.txt plansza1-emisja 01:00:00:00
7 22-04-2011 22:15:49:08 [null] asrun_22-04-2011.txt plansza1-emisja 01:00:00:00
8 22-04-2011 23:15:49:08 [null] asrun_22-04-2011.txt plansza1-emisja 01:00:00:00
9 23-04-2011 00:15:49:08 [null] asrun_22-04-2011.txt plansza1-emisja 01:00:00:00
10 23-04-2011 01:15:49:08 [null] asrun_22-04-2011.txt plansza1-emisja 01:00:00:00
11 23-04-2011 02:15:49:08 [null] asrun_22-04-2011.txt plansza1-emisja 01:00:00:00
12 23-04-2011 03:15:49:08 [null] asrun_22-04-2011.txt plansza1-emisja 01:00:00:00
13 23-04-2011 04:15:49:08 [null] asrun_22-04-2011.txt plansza1-emisja 01:00:00:00
125 06-04-2011 08:00:28:02 [null] asrun_06-04-2011.txt jingiel-emisja 00:00:05:00
126 06-04-2011 08:00:33:02 [null] asrun_06-04-2011.txt kns1-emisja 00:00:06:23
127 06-04-2011 08:00:40:00 [null] asrun_06-04-2011.txt kns2-emisja 00:01:20:17
128 06-04-2011 08:00:40:00 [null] asrun_06-04-2011.txt kns2-emisja 00:01:23:17
I want:
1 22-04-2011 06:14:04:06 [null] asrun_22-04-2011.txt plansza-emisja 01:00:00:00
3 22-04-2011 08:00:00:06 [null] asrun_22-04-2011.txt jingiel-emisja 00:00:05:00
5 22-04-2011 20:15:49:08 [null] asrun_22-04-2011.txt plansza1-emisja 01:00:00:00
125 06-04-2011 08:00:28:02 [null] asrun_06-04-2011.txt jingiel-emisja 00:00:05:00
126 06-04-2011 08:00:33:02 [null] asrun_06-04-2011.txt kns1-emisja 00:00:06:23
127 06-04-2011 08:00:40:00 [null] asrun_06-04-2011.txt kns2-emisja 00:01:20:17
128 06-04-2011 08:00:40:00 [null] asrun_06-04-2011.txt kns2-emisja 00:01:23:17
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment