Primary key multiple

CREATE TABLE Persons (
    Rollno int NOT NULL,
    FirstName varchar(30),
    LastName varchar(30) NOT NULL,
    class varhcar(20),
    Age int,
    CONSTRAINT PK_Student PRIMARY KEY (Rollno,LastName)
);

Source: computerscienceai.com

Similar codes

6 votes259 views1 answer
How to count number of rows in sql
SQL
3 votes265 views1 answer
Convert sqlite table to pandas dataframe
SQL
0 vote287 views2 answers
Mysql calcular idade
SQL
1 vote276 views1 answer
Woocommerce mysql price table
SQL
3 votes261 views1 answer
Oracle limit user tablespace
SQL
0 vote271 views1 answer
How to create a table in sql stack overflow
SQL
1 vote267 views1 answer
Sql sort column by date
SQL
0 vote287 views1 answer
Mysql where in maintain order
SQL
0 vote253 views1 answer
Como verificar registros duplicados no sql postgresql
SQL
0 vote283 views1 answer
How to reset the database value in SQL server
SQL