sql queries:

 create database db0;

use db0;


create table employee_details(id int, name varchar(255),place varchar(255),salary int);

create table purchase_details(name varchar(255), place varchar(255),amount int);


insert into employee_details(id,name,place,salary)

values ('10','nandhini','coimbatore','40000');


insert into employee_details(id,name,place,salary)

values ('20','kavitha','chennai','60000');


insert into employee_details(id,name,place,salary)

values ('30','arun','us','45000');


insert into employee_details(id,name,place,salary)

values ('40','arul','delhi','70000');



insert into employee_details(id,name,place,salary)

values ('50','priya','calfornia','90000');


insert into employee_details(id,name,place,salary)

values ('60','sarala','russia','100000');


select * from employee_details;


insert into employee_details(id,name,place,salary)

values ('70','thippu','puram','200000');


select * from employee_details;



insert into employee_details(id,name,place,salary)

values ('80','annai','ooty','200000');


insert into employee_details(id,name,place,salary)

values ('90','prabhu','kodaikanal','200000');



insert into employee_details(id,name,place,salary)

values ('100','selvam','pandichery','200000');


select * from employee_details;


select distinct name from employee_details;






select * from employee_details;


select name from employee_details where salary = 45000;


select * from employee_details where name='arun';


select * from employee_details;


select place from employee_details where id =20;


select * from employee_details where name ='arul';



select name from employee_details;



select name,id from employee_details;


select distinct name from employee_details;


select * from employee_details;


select name from employee_details  where id = 10;

select * from employee_details where name='nandhini';

select name from employee_details;



select name from employee_details where salary >50000;


select *from employee_details where name ='arul';


select * from employee_details;


select * from employee_details where salary > 70000 and place = 'ooty';


select * from employee_details;


select * from employee_details order by id;


select * from employee_details order by id DESC;


select * from employee_details where id in (100,90,60,70);


select * from employee_details where id = 60 and salary = 10000;

select * from employee_details where salary >50000 and place = 'ooty';

select * from employee_details where name = 'priya' and salary = 45000;

select * from employee_details where id = 10 OR name = 'navin';

select * from employee_details where id = 20 AND name = 'navin';

select * from employee_details where not id = 10;












select * from employee_details where not name ='arun';


select * from employee_details where id = 10 AND place='coimbatore';

select * from employee_details where salary > 45000 AND name ='arul';


select * from employee_details where id = 10 or name = 'poorani';


select * from employee_details where id in (10,70,80,40);


backup database db0 

 to DISK = 'sql today'

 WITH DIFFERENTIAL ;

differential usees to reduces the data backup time 

how to restore the data back into sql:


















































Comments

Post a Comment

Popular posts from this blog

Linux interview Questions :

 1).How to recover accidently deleted /etc/fstab into linux os ? anyone deleted this /etc/fstab .after this we can' boot ur os. boot into recovery mode . then go to the linux terminal page . here we have to execute the blkid command  here it will list out the avilble partions and attached filesystems . if your deleting the /etc/fatab.that time root parttion won't be work  now we can mount the root parttion in rw mode mount -t ext4 -0 rw,remount dev/sda1 / 2).VMSTAT command into linux ? 3).iostat and dstat command into linux os ? 4).LInux free command into linux os ? in this way we can check it our the memeory usage and swap memeory as well. then it will display out the , used,space avilble ,total ,buffer/catche abd shared what is free space we can execute the command like as the, free -b command : we will get the particular output for the bits  so if you want to getto int the outpit in kilobytes : so we can execut ethe comamnd like as the, free -k free -g: it will sh...
Read more
 Aws Certification Manager into aws environment: 1).first we need to create the vpc  2).next things we have to create the two public  subnets based on multiple avilibity zones we can craete the multiple subnets . 3).setup the the internet gateway  4).next internet gateway is needed to attach with the  vpc . 5).setup the route table  next am going to associate the all subnets into route tables which we are careted. next am going to add the igw for public subnets routes --------------------------------------------- setup the ec2 instances: while lancing the ec2 server , we have to choose the  vpc and public subnets and added into that. here we need to install the and configure the apache webserver ---------------------------------------- setup the loadbalnacer firsts we need to create the target group and add the ec2 servers. then we can to create the load balancer and add the target group inside it . ---------------------------- we dont want use loadnal...
Read more

SQL Interview Questions:

 SQL Interview Questions: sql interview questions: 1).What is sql? 2).what are the subsets of sql? ddl -dattruncatea definitaion laungade = create ,alter,drop, dml dcl tcl --------------------- 1).create the database : insert,update,delete,select sql for beginners : 1).how to create the table? 2).How to insert the values and rows into the tables? 3).How to update the table into sql? for example am entring the john age is wrong. so i need to chnage the 25 . so for that situvation we have to use the upadte command into sql . so , we can execute the command like as the, update student  set  age =23 where name='john';   4).How to delete the rows from the paticular tables and delete the compeplete table? ------------------------------------------------------ 1).How to create the customer table into sql databases? 1)sql practice questions? 1).How to create the customer table into sql? create table customer (customer_id varchar(200),customer_name varchar(200),customer_addre...
Read more