Write SQL statements to insert two records into the Student table: (i) RollNo 1, Name 'Aarti Deshpande', Class 'XI-A', Marks 78; (ii) RollNo 2, Name 'Rohan Patil', Class 'XI-A', Marks 85.

Question

Accepted Answer

To add a record to a table we use the **`INSERT INTO`** statement, naming the table and its fields and then giving the `VALUES` in the same order. **Text values are written inside single quotes; numbers are written without quotes.** We write one `INSERT` statement per record.

(i) For RollNo 1:

```sql
INSERT INTO Student (RollNo, Name, Class, Marks)
VALUES (1, 'Aarti Deshpande', 'XI-A', 78);
```

(ii) For RollNo 2:

```sql
INSERT INTO Student (RollNo, Name, Class, Marks)
VALUES (2, 'Rohan Patil', 'XI-A', 85);
``` …

Q.Write SQL statements to insert two records into the Student table:

Concept understanding — SQL Basics (CREATE, INSERT, SELECT)

Q.Write SQL statements to insert two records into the Student table:

🎓Unlock everything free for 14 days

Unlock everything free for 14 days