And to this day, we will learn about a court in poverty, so let's go to the poverty created by clicking
on Tosspot.
So first we will need to know that what's the difference between list and.
Records so list is based on a single column, like, for example, if we want to make a list for the
ship date, what we have to do is we just need to click effects and then we need to write the name of
the column ship date.
So this is a list, right?
And list always based on the single column and all the roles within a single column.
And what is record record consist of more than one columns.
Right?
Like if I click here like four and here you can see this is the record, the record that is available
at 44.
Right.
And if I click on 28.
So here we are getting the data for this row and it contains all the columns, as you can see here.
Right.
So let's try to create a one simple record by our own.
Just we just need to.
Right.
Click here and go to the blank here.
We have to write.
Bracket and then.
The name of the column will be like employed, employed, it's equal to one.
Here and here, you can see this is the single record, like we have one attribute, the head of the
column, and this is the value, and then we can write one more
like a name is equal to first and this is the second.
And then we we can right here, like, um, great.
This is consultant, right?
So this is on the court, so if you're free.
So what will happen if we're right here?
The curly bracket and then close the so-called they.
So what we will get.
We will get one list right?
So here you can see the list and this list is consist of one record here.
Right, and because everything that goes right in between the Carlebach, it is called list, and let's
try to add one more record here.
So what you can do is we just need to copy this record and then comma and here and right, so here they
employ the name is to the ideas to and the name is Testa.
And this is.
Like a manager.
So.
We have one list that consists of two records.
So now we need to confirm it and here you can see we are getting two records and you click here.
You can see this is the first record that can one and this is the second record.
Right.
And then we can convert this list into table if we want to perform some type of functions on it.
So we just need to click the we need to click the source and then convert to table.
So we are getting a table with one column and it contains two records, this one and this one.
Let's go back to the source again.
And so let's make a copy, particularly two and we can write here, query three and we can remove the
the list and the the second record.
So here you can see this is the single record right now.
We have to learn how we can access the individual attribute like I mean, to say in grade, then what
I can do, as I know that this is a record, it is returning me on record.
And if I want to fetch the trade consultant, then what I have to do is what I need right here.
PRICKETT And then the name of the header.
That is great.
And here you can see this is a consultant, right?
So in this way, we can get anything like employee employee I.D. and here this is the employer, right?
So if we have a record, then we can get to any particular item from that record with the help of.
It's happening, so let's go to the first temple, said Setara, and I can control state control copy
and this is the name of this is Zelada three and I am entrusted to fetch the this order number one one
seven so high.
How can I fetch this record?
So always remember this thing when we will talk about our record.
The index will start from zero zero percent, one, two and so on.
So how we can.
Get this value, this record that is available on the 17th position.
We just need to click effects here, we have to write it, and as we are in 2017, then the index for
this one will be 16.
So here you can see we are able to fetch the record that is available at 16th position, and if we are
entrusted to fetch wholesale for what we will do, we just need to.
Right here, Prickett, and then the name of the header is General.
You can see they say we are interested in.
We are entrusted to fetch wholesale.
So the name of the call will be channel.
So this is wholesale, right.
So in the same way, we can fetch anything for the people I delayed.
Question one.
So we are interested here.
Number 81.
So what you can do is we just need to click effect's.
And here we have the right curly bracket.
And.
The index will be 80 and then we need to write the header, so which way we are we want to fetch.
So the name of the terrorist column, header or number?
So camera, so you can see we are getting 181.
So that's all about list and records and poverty and the next will you will try to to do one practical
example for how we can use records in real life.