...
/Quiz on Counting, Sorting, and Limiting Results
Quiz on Counting, Sorting, and Limiting Results
Test your understanding of the create table, index, count, where, and order by commands.
We'll cover the following...
We'll cover the following...
1.
Create the items table. Items should have
item_id as the primary key (integer, not null and auto incremented),
a description of type varchar with maximum length of 255, and the rate of
type numeric with 5 digits before and 2 digits after decimal point. Both description and rate should not be null.
0/500
Show Answer
1 / 7
MySQL
SELECT 'Hello World';
...