MySQL , MySQL - rextester

MySQL

create table STUDENT_TABLE(ROLLNO Integer,NAME Varchar(10),GENDER char(1),MARKS Float,DOB Date,Mob_no Integer,CITY Varchar(15));
                 insert into STUDENT_TABLE values(101,'A','M',95,'1998-02-12',580,'JAMNAGAR');
                 insert into STUDENT_TABLE values(102,'B','F',96,'1998-02-13',581,'DWARKA');
                 insert into STUDENT_TABLE values(103,'C','M',97,'1998-02-14',582,'RAJKOT');
                 insert into STUDENT_TABLE values(104,'D','F',98,'1998-02-15',583,'AHMEDABAD');
                 insert into STUDENT_TABLE values(105,'E','M',100,'1998-02-17',584,'GANGHINAGAR');
                 insert into STUDENT_TABLE values(106,'F','F',100,'1998-02-18',585,'VADODRA');
                 insert into STUDENT_TABLE values(107,'G','M',98,'1998-02-19',586,'DELHI');
                 insert into STUDENT_TABLE values(108,'H','F',97,'1998-02-20',587,'MUMBAI');
                 insert into STUDENT_TABLE values(109,'I','M',96,'1998-02-21',588,'CHENNAI');
                 insert into STUDENT_TABLE values(110,'J','F',95,'1998-02-22',589,'BHOPAL');
                 Select * from STUDENT_TABLE;


run \| edit \| history \| help	0