Chat with our AI personalities
In sql you use primary key more than one column in a table
No, 2.5 is less than 3. To compare numbers starting with the highest place value column compare the digits, moving right a place value column until either all digits have been considered or one digit is higher than the other. If a place value column is empty, its digit value is 0: For 2.5 and 3 the highest place value column is the ones column In 2.5 the ones column is 2 and in 3 the ones column is 3; 2 is less than 3, so 2.5 is less than 3.
primary key is a column or set of columns (called composite primary key ) that identify the table & make every table unique .value of a primary key can not duplicated & can not be NULL .
To compare numbers starting with the highest place value column compare the digits, moving right a place value column until either all digits have been considered or one digit is higher than the other. If a place value column is empty, its digit value is 0: The highest place value is the tens: they both have a 4, so move right a column In the ones column they both have an 8, so move right a column In the tenths column they both have a 7, so move right a column In the hundredths column they both have a 5, so move right a column In the thousandths column 48.7513 has a 1, but 48.753 has a 3; 1 is less than 3 so 48.7513 is less than 48.753 48.7513 is less than 48.753
To compare numbers compare the largest place value column first, and then the next largest and so on until one number has a greater place value column digit than the other or all place value columns have be compared Both 2.85 and 2.8 have a 2 in the ones column, so test the next column: Both 2.85 and 2.8 have a 8 in the tenths column, so test the next column: 2.85 has a 5 in the hundredths column, but 2.8 has nothing, which can be read as zero, in the hundredths column; 5 is greater than 0 so 2.85 is greater than 2.8 2.85 is greater than 2.8