COLLEGE DETAILS IN SQL

SQL> create table college(sno int,courseapplied varchar2(20),eligibility varchar2(10),mark varchar2(10),fees varchar2(10));

Table created.

SQL> insert into college values('&sno','&courseapplied','&eligibility','&mark','&fees');

Enter value for sno: 1

Enter value for courseapplied:  mca-tech

Enter value for eligibility: ug

Enter value for mark: 60%

Enter value for fees: 45000

1 row created.

SQL> select * from college;

       SNO       COURSEAPPLIED        ELIGIBILIT      MARK       FEES

       ----------   --------------------            ----------              ----------      ----------

         1             mca-tech                        ug                       75%        45000

         2             mca-nontech                  ug                       60%        25000

         3             mba                                ug                       65%        30000

SQL>  update college set mark='75%' where sno=1;

1 row updated.

SQL> select mark from college;

MARK

----------

75%

60%

65%

SQL> select courseapplied from college;

COURSEAPPLIED

--------------------

mca-tech

mca-nontech

mba

SQL> select min(fees) from college;

MIN(FEES)

----------

25000

SQL> select max(fees) from college;

MAX(FEES)

----------

45000