dbms assignment answers - Assignment no 1 create table...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Assignment no 1 create table stud (prn varchar(10) primary key,FirstName varchar(30),LastName varchar(30),DOB date,city varchar(20),course varchar(10),sem varchar(5),depositedFees float(10,2),examFees float(10,2)); ------------------------------------------------------------------------------------------------------------ Assignment no II: queries : 1 >select FirstName,LastName from stud where city='Pune' or city='Mumbai'; 2>select FirstName,LastName from stud where course='MBA' and sem='IV'; 3>desc stud; 4>select FirstName,LastName from stud where depositedFees>10000; 5> select FirstName,LastName from stud order by FirstName; 6>show tables; 7>select FirstName,LastName from stud where course ='MSC' and sem='IV' and depositedFees>5000 and depositedFees<10000;
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
8> select FirstName,LastName from stud where depositedFees=0; 9> select FirstName,LastName from stud where FirstName like 'A%' group by (FirstName); 10> select FirstName,LastName from stud where length(FirstName)=5 group by (FirstName);
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

Page1 / 4

dbms assignment answers - Assignment no 1 create table...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online