Query to get records using Keys

Question

steve needs to create a table with the students. the table should have a composite unique key that is created by using the Roll_no and Class column.

table has Students (Roll_No int, class int, first_name varchar(20), Last_name varchar(20), Address varchar(20))

Answer It Please...

Bikesh Srivastava · Answer

You can use joins..

Salman · Answer

Hi. First create the table and then ALTER TABLE Students ADD CONSTRAINT unique_1 UNIQUE ( Roll_no  Class ) Otherwise you can do like this CREATE TABLE Students( Roll_No int class int first_name varchar(20) Last_name varchar(20) Address varchar(20) CONSTRAINT unique_1 UNIQUE (Roll_No class) ) Thanks.