SQL Queries
drop database pgm;
create database pgm;
create table persons
(PersonID int,
LastName varchar(255),
FirstName varchar(255),
City varchar(255),
State varchar(255));
use pgm;
select * from persons;
insert into persons(ID,name,age,city) values
(1,'sandhya',22,'mpl'),
(2,'lalitha',23,'mpl'),
(3,'siri',23,'hindupur'),
(4,'vyshu',23,'kadapa'),
(5,'gowthami',22,'vayalpadu'),
(6,'reddy',24,'mpl');
select 3*5;
select *
from persons
where ID=3;
Comments
Post a Comment