Would you like to inspect the original subtitles? These are the user uploaded subtitles that are being translated:
0
1
00:00:02,560 --> 00:00:03,328
Hi everyone
1
2
00:00:04,096 --> 00:00:08,960
Now that we have learnt about views it is time to do an exercise on views
2
3
00:00:09,216 --> 00:00:11,264
It's a very simple exercise
3
4
00:00:11,776 --> 00:00:17,920
You just need to create a view which contains order line product ID sales and discount value of the first
4
5
00:00:18,176 --> 00:00:18,944
Order date
5
6
00:00:19,200 --> 00:00:22,784
See you first find out the what is the first order date
6
7
00:00:23,040 --> 00:00:23,552
in your
7
8
00:00:23,808 --> 00:00:24,576
Sales table
8
9
00:00:25,856 --> 00:00:26,368
Then
9
10
00:00:26,624 --> 00:00:30,464
Use this to put a condition when you are getting resultset
10
11
00:00:30,720 --> 00:00:33,024
and the name of this view will be
11
12
00:00:33,280 --> 00:00:34,304
Daily billing
12
13
00:00:35,584 --> 00:00:36,864
Once you have created this you
13
14
00:00:37,120 --> 00:00:38,144
Delete it
14
15
00:00:38,656 --> 00:00:42,752
And with this you'll know how to create and delete a view
15
16
00:00:43,008 --> 00:00:44,288
If you face any difficulty
16
17
00:00:44,544 --> 00:00:46,592
Remember to post it in discussion forum
1278
Can't find what you're looking for?
Get subtitles in any language from opensubtitles.com, and translate them here.