Saved Bookmarks
| 1. |
Write SQL statements for following:Student( Enrno, name, courseId, emailId, cellno)Course(courseId, course_nm, duration)i) Add a column city in student table.ii) Find out list of students who have enrolled in “computer” course.iii) List name of all courses with their duration.iv) List name of all students start with „a‟.v) List email Id and cell no of all mechanical engineering students. |
|
Answer» Answer: SQL CREATE TABLE statement is USED to create table in a DATABASE. If you want to create a table, you should name the table and define its COLUMN and each column's DATA type. ... SQL CREATE TABLE create table "tablename" ("column1" "data type", "COLUMN2" "data type", "column3" "data type", ... Explanation: mark as brainlest |
|