Programming Logic and Code: SQL INTERVIEW QUESTIONS FOR 15 MONTHES EXPERIANCE

This post have all the query and synatx which a biggner and experianced SQL users need to know and use in their daily working Life.

1 :- SQL INSERT

Syntax 1 :-Template for all columns update --

insert into Table_name value('ABC','ART','',.....,'Value n')
-- Note data type of each column should be match

Syntax 2:- Template for slelect columns update --

insert into Table_name(col_1,col_2,,,,,,,, col_n) value('ABC','ART','',.....,'Value n')

Syntax 3:- If all rows have to be fill up

insert Into Parameter_Blood_Group values('B0100A000004','GEN00A000001','AB-','AB-','0','2','Approved','','2019-05-04 17:27:58.913')

Syntax 4:- If select rows have to be fill up

insert Into Parameter_Blood_Group(URN_No,Co_code) values('B0100A000004','GEN00A000001')

Syntax 5:-Without index column is exists in Table

Example 1- Insert into 'table_name' (Col_1,Col_2,......,Col_n)
Values(Value_1,Value_2,.....,Value_n);

Initial Table - Table Name- User_Detail

Example 2- Insert into User_Detail (User_name,User_Mobile,User_email_id,Pin_code)
Values('Programming Logic World',1234512345,'programminglogicworld@gmail.com',123456);

SQL LIKE Operator

Sql Query to select similar kind of data which have perticular pattern comman in their specipic data column

Basic Format

SELECT col1, col2, ...,columnN
FROM table_name
WHERE columnN LIKE pattern;

Demo-

SELECT * FROM Student
WHERE StudentName LIKE 'a%';

Note:- Like Operator Consume Maximum Resources

Like Operator Usage

Search Type 1:-

All Students with a column name 'StudentName' that start with "s" in the Second position:
SELECT * FROM Students
WHERE Student_Name LIKE '_s%';

Search Type 2:-

All Students with a column name 'StudentName' that have "s" in the Third position:
SELECT * FROM Students
WHERE Student_Name LIKE '__s%';

Search Type 3:-

All Students with a column name 'StudentName' that have "s" in the Fourth position:
SELECT * FROM Students
WHERE Student_Name LIKE '___s%';

Search Type 4:-

All Students with a column name 'StudentName' that start with "s"

SELECT * FROM Students
WHERE Student_Name LIKE 's%';

Search Type 5:-

All Students with a column name 'StudentName' that start with "sa"
SELECT * FROM Students
WHERE Student_Name LIKE 'sa%';

Search Type 6:-

All Students with a column name 'StudentName' that start with "saw"
SELECT * FROM Students
WHERE Student_Name LIKE 'saw%';

Search Type 7:-

All Students with a column name 'StudentName' that end with "s"
SELECT * FROM Students
WHERE Student_Name LIKE '%s';

Search Type 8:-

All Students with a column name 'StudentName' that end with "sa"
SELECT * FROM Students
WHERE Student_Name LIKE '%sa';

Search Type 9:-

All Students with a column name 'StudentName' that end with "saw"
SELECT * FROM Students
WHERE Student_Name LIKE '%saw';

SQL Distinct Opeartor

SELECT DISTINCT column1, column2, ...
FROM table_name;

Query:-

Select Distinct it_name,it_code from Item_Master

Note- we use Distinct keyword to find unique data of columns.

SELECT DISTINCT column1, column2, ...
FROM table_name;

DEmo Table Data Rows- 10000

Query-

Select Distinct it_name from Item_Master
Result- 10

Note- we use Distinct keyword to find unique data of column.

Select Distinct it_name,it_code from Item_Master
Result- 159

Note- we use Distinct keyword to find unique data of two columns.

Select Distinct it_name,it_code,uom from Item_Master
Result-1547

Note- we use Distinct keyword to find unique data of three Columns.

Select Distinct it_name,* from Item_Master
Result- 5000

Note- we use Distinct keyword to find unique data of column.

Select Distinct it_name,it_code,* from Item_Master
Result- 5000

Note- we use Distinct keyword to find unique data of two columns.

Select Distinct it_name,it_code,uom,* from Item_Master
Result- 5000

Note- we use Distinct keyword to find unique data of three Columns.

As all programming language have operator for conditions in the same way SQL have following operator
1- AND
2- OR
3- NOT

1- AND
Operator is used when we want both the conditions must be true.
Syntax- Select * from table_name
where condition1 and condition2 and condition3

2- OR
Operator is used when we want only single the conditions must be true.
Syntax- Select * from table_name
where condition1 or condition2 or condition3

3- NOT
Operator is used when we want conditions must not be true.
Syntax- Select * from table_name

where Not condition1

JOIN

SQL Joins is used to Compose the data of two table into a single view-

SQL Joins are Five Types-

1- Inner Joins
2- Left Outer Joins
3- Right outer Joins
4- Full Joins
5- Self Joins

Inner Joins syntax

select * from table A
INNER join table B on A.ID=B.ID

Result- Only the common data from both table which have ID in both table

Left Joins syntax

select * from table A
LEFT outer join table B on A.ID=B.ID

Result- All data from table A and matched data from table B where id of a Exists in B

Rights Joins Syntax

select * from table A
RIGHT outer join table B on A.ID=B.ID

Result- All data from table B and matched data from table A where id of a Exists in A

Full joins Joins Syntax

select * from table A
FULL OUTER join table B on A.ID=B.ID

Result- All data from table A and B and All A data whose ID not in B and A data whose ID not in B and Common of A& B no duplicate ID

Self JoinsSyntax

select * from Sawanchauhan A
left outer join Sawanchauhan B
where A.PermanentCity=B.CurrentCity

Result- All data from table (SawanChauhan) where permanenet city and current city are same only.

Where Clause Uses

Sql where keyword is used to filter the records

Syntax- Select Col1,Col2,Col3 from table_name where condition;

select item_name,Item_code,Item_uom from item_master where created_By_Id=12

Pages

Search the Blog

Sunday, May 9, 2021

SQL INTERVIEW QUESTIONS FOR 15 MONTHES EXPERIANCE