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 show the o th
Read more
 Aws Interview Questions: 1).How to troubleshoot  the aws ec2 kernel panic issue in cloud environment? How to troubleshoot the aws kernel panic issues in aws cloud? 1).Take the snapshot for panic instances 2).create new instances in same avilibity zone 3).detach the root volume from panic instance and attach  to the rescue instances  4).mount the panic instances and restore the kernel version 5).stop the recue instances and detach the root volume and  reattach the rescue instances  so, In this way we can troubleshoot the aws kernel  panic issue. run the following commands , to verify the root volume is attached to the rescue instances. lsblk = its list out the block devices craete the mount point and mount to the disk  next we need to mount the /dev, /run,/proc, /sys sudo mount -o bind /dev /mount/dev sudo mount -o bind /sys /mount/sys sudo mount -o bind /proc /mount/proc sudo mount -o bind /ys /mount/sys run the chroot command on the mounted/mnt file system chroot /mnt sudo grub2-mkco
Read more

AWs Interview Questions

 1).How to troubleshoot the aws ec2 kernel panic issue into aws environment? stop the ec2 instances take the snapshot for panic ec2 instances  2).How to recover the elastic ip which you are missing? recovering the elastic ipddress for using below methods: you cannot recover the elastic ipaddress. maybe those ipaddress are allocated to the another aws account exceeding your elastic ip address limit. we can recover the elastic ipaddress using he aws ec2 api or cli only copy the ipaddress somewhere go to the Cmd prompt: and login using the aws configure . aws ec2 allocate-address --domain vpc --address elastic ipaddress  in this way we can recover the elastic ip .. 3).ssh is not connecting . So how to troubleshoot the issue with in it ? first checking the security groups next we have to check the public subnet (weather the igw route is added or not) next am going to check the status check of your instances  instances status check and system status check we have to check the key file permi
Read more