SQL Basic Interview Questions:

SQl interview questions:
1).
How to create the database in sql ?
create database database_name1;
use database_name1



3).









2).How to create the table in sql ?
create table emp_details (id int, name varchar(255),place varchar(255),
salary int);



How to create the add or insert the rows into table?
insert into emp_tour (id ,name,place,salary)
values ('40', 'anna','chennai','79900');
insert into emp_tour(id,name,place,salary)
values ('90', 'roja','us','60000');
insert into emp_tour(id,name,place,salary)
values ('70','pooja','london','45000');
insert into emp_tour(id,name,place,salary)
values ('70','pooja','london','45000');

insert into emp_tour(id,name,place,salary)
values ('70','selvam','rusia','450000');




4).How to view the table in sql?

select * from emp_tour;

5).
How to fetch the all data from employee table?
select * from emp_tour;
in this way we can fetch the all details
6)..
I want to view the name of the employess from employee table ?
so how can i view?
select name ,place from table_name;
select name,place from emp_tour;

7).How to get the lowest and hightest salary value in sql?
select MAx(salary),min(salary) from table name ;
select Max(salary), Min(salary) from emp_tour;

8).
How can i fetch the distinct record into this table?
How to display the duplicate values from tables?

How to delete the duplicate data from table ?
select distinct name from table_name 




9).
How to display the lowest and highest salary  for each department ?
using orderby and desc comamnd in sql
or 
seelct max(salary), min(sslary) from table_name;

10)..
How can we filter the record or data from the table ?
select * from emp_tour where id = '10'
who is salary is greather then 100000?
sleetc * from emp_tour where salary > = 100000;

11). How to decending and ascending the data  using order by comamnd in sql?(How to sort the record )?

aasecding = arrange to smallest to highet
dec = aargge to highest to smallest
select * from table name order by salary ;
select * from table_name order by salary DESC;


12).How to modify(rename)  or update the table in sql?
How to rename the table ?
alter table oldtable name rename newtable name
13).backup database in sql:
backup database nandhini
to disk = 'directory name';




Comments

Post a Comment

Popular posts from this blog

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
 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

Linux interview questions

 1).what is the differnece between dnf and yum pacakges  into linux os ? whatever activity we can do in yum packages , we can do the same activity into dnf packages its. dnf packages :  its provides the beter speed , performance and less memory consumptions . this is the updated version of yum packages. now am going to execute the command like as the , time dnf install package name -y time yum install package name -y after updating this packages into system , we have to see the time differences. 2).How to block the root user account into the server for ssh? 3).what is the  difference between iostat and dstat in linux os ? 4)linux Monir ting cli commands  5).Differences between linux 7 and linux 8 ? 6)difference between init vs systemd in linux os ? init : init is used to boot the process 7).what could be the reasons of a non bootable linux  system or server? boot loader issue : corrupted grub  incorrect boot loader settings file system corruption kerne...
Read more