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

Popular posts from this blog

SQL Queries

SQL Queries

SQL Queries