Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- create table train_details(
- train_no int,
- train_src varchar(255),
- train_dest varchar(255),
- train_arr_time time,
- train_dep_time time,
- train_seat_total_seats int,
- train_seats_booked int,
- train_seats_vacant int
- );
- insert into train_details values(22547,'Kanya Kumari','Jammu','19:20:00','19:30:00',380,80,300);
- select * from train_details where train_src='Delhi' and train_dest='Varanasi';
- select * from train_details where train_src='Kanya Kumari' and train_dest='Jammu';
- select train_no,train_src from train_details where train_dest='Delhi';
- select * from train_details where train_dest<>'Gaziabad';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement