SQL Query File Prog.
SQL Query File Prog.
INNER JOIN
EMP_ID EMP_NAME EMP_LAST_NAME EMM_CODE
1 ANNAD WADE 100
2 RAMA WADE 200
3 RAJSHREE WADE 300
4 MUKESH WADE 400
5 AMRUT WADE 500
6 NEELA WADE 600
DEPT_ID DEPT_NAME SALARY
1 1 DEFENCE 500,000
2 2 ARMY 400000
3 3 EDUCATION 100000
4 4 IT 200000
5 5 CORPORATION 50000
6 6 HOUSE 0
SELECT * FROM JOIN_iNNER_EMP_1 INNER JOIN JOIN_INNER_EMP_2_DEPT ON JOIN_iNNER_EMP_1.EMP_ID =JO
Jan-24
SUN 0 7
MON 1 8
TUE 2 9
WED 3 10
THU 4 11
FRI 5 12
SAT 6 13
innner join
dt 30-jan-2024 familyid name middle_name
1 AMRUT JAYRAM
2 NEELA AMRUT
3 MUKESH AMRUT
4 RAJSHREE MUKESH
5 RAMA MUKESH
6 ANAND MUKESH
ID NAME DEPT
1 AMRUT RETD
5 RAMA STUDENT
6 ARIHANT CHILDHOOD
ID NAME SALARY
1 AMRUT 22000
2 NEELA 0
3 MUKESH 20000
4 RAJSHREE 4000
5 RAMA DEPENDENT
6 ARIHANT DEPENDENT
RE stu_id= 'AMRUT'
POST
INSERT INTO JOIN_INNER_EMP_2_DEPT
FLYING OFFCER (DEPT_ID,DEPT_NAME,SALARY,POST)VALUES(' 1 ',' DEFENCE ',' 500000 ',' FLYING OFFCER ')
INSERT INTO JOIN_INNER_EMP_2_DEPT
DOCTOR (DEPT_ID,DEPT_NAME,SALARY,POST)VALUES(' 2 ',' ARMY ',' 400000 ',' DOCTOR ')
INSERT INTO JOIN_INNER_EMP_2_DEPT
TEACHER (DEPT_ID,DEPT_NAME,SALARY,POST)VALUES(' 3 ',' EDUCATION ',' 100000 ',' TEACHER ')
INSERT INTO JOIN_INNER_EMP_2_DEPT
IT DEVELOPER (DEPT_ID,DEPT_NAME,SALARY,POST)VALUES(' 4 ',' IT ',' 200000 ',' IT DEVELOPER ')
INSERT INTO JOIN_INNER_EMP_2_DEPT
FIREMAN (DEPT_ID,DEPT_NAME,SALARY,POST)VALUES(' 5 ',' CORPORATION ',' 50000 ',' FIREMAN ')
INSERT INTO JOIN_INNER_EMP_2_DEPT
HOME (DEPT_ID,DEPT_NAME,SALARY,POST)VALUES(' 6 ',' HOUSE ',' 0 ',' HOME ')
_DEPT ON JOIN_iNNER_EMP_1.EMP_ID =JOIN_INNER_EMP_2_DEPT.DEPT_ID
INSERT INTO family1 (familyid,name ,middle_name,city) VALUES (' 1 ', ' AMRUT ', ' JAYRAM ', ' CHOPDA ')
INSERT INTO family1 (familyid,name ,middle_name,city) VALUES (' 2 ', ' NEELA ', ' AMRUT ', ' PUNE ')
INSERT INTO family1 (familyid,name ,middle_name,city) VALUES (' 3 ', ' MUKESH ', ' AMRUT ', ' PUNE ')
INSERT INTO family1 (familyid,name ,middle_name,city) VALUES (' 4 ', ' RAJSHREE ', ' MUKESH ', ' PUNE ')
INSERT INTO family1 (familyid,name ,middle_name,city) VALUES (' 5 ', ' RAMA ', ' MUKESH ', ' PUNE ')
INSERT INTO family1 (familyid,name ,middle_name,city) VALUES (' 6 ', ' ANAND ', ' MUKESH ', ' PUNE ')
INSERT INTO (familyid,name ,middle_name,city) VALUES (' 1 ', ' AMRUT ', ' RETD ', ' 75 ')
INSERT INTO FAMILY2(FAMILIY_ID,NAME,WORK,AGE) VALUES (' 1', ' AMRUT', ' RETD', ' 75')
INSERT INTO FAMILY2(FAMILY_ID,NAME,WORK,AGE) VALUES (' 2', ' NEELA', ' HOME MAKER', ' 65')
INSERT INTO FAMILY2(FAMILY_ID,NAME,WORK,AGE) VALUES (' 3', ' MUKESH', ' JOB IT SECTOR', ' 38')
INSERT INTO FAMILY2(FAMILY_ID,NAME,WORK,AGE) VALUES (' 4', ' RAJSHREE', ' JOB TEACHER', ' 34')
INSERT INTO FAMILY2(FAMILY_ID,NAME,WORK,AGE) VALUES (' 5', ' RAMA', ' STUDENT', ' 4')
INSERT INTO FAMILY2(FAMILY_ID,NAME,WORK,AGE) VALUES (' 6', ' ANAND', ' CHILDHOOD', ' 2 MONTH')
dob
Monday, January 1, 1951 01-01-1951
01 January 1960 01-01-1960
07-31-1984 07-31-1984
Friday, July 31, 1987 31-07-1987
Sunday, August 11, 2019 11-08-2019
Monday, October 8, 2029 08-10-2029
) )
E_Add INSERT INTO inner1(ID,FIRST_NAME, MIDDLE_NAME,LAST_NAME,E_ADD)VALUES( ' 1
CHOPDA INSERT INTO inner1(ID,FIRST_NAME, MIDDLE_NAME,LAST_NAME,E_ADD)VALUES( ' 2
PUNE INSERT INTO inner1(ID,FIRST_NAME, MIDDLE_NAME,LAST_NAME,E_ADD)VALUES( ' 3
PUNE INSERT INTO inner1(ID,FIRST_NAME, MIDDLE_NAME,LAST_NAME,E_ADD)VALUES( ' 4
PUNE INSERT INTO inner1(ID,FIRST_NAME, MIDDLE_NAME,LAST_NAME,E_ADD)VALUES( ' 5
PUNE INSERT INTO inner1(ID,FIRST_NAME, MIDDLE_NAME,LAST_NAME,E_ADD)VALUES( ' 6
PUNE INSERT INTO inner1(ID,FIRST_NAME, MIDDLE_NAME,LAST_NAME,E_ADD)( ' 3 ', ', ',
DATE AN D TIME
INSERT INTO date_time ( id,name,
DOB,)VALUES( ' 1 ', ' AMRUT ', ' 01-01-
1951- 12:10:12 ')
INSERT INTO INN_DEPT2(ID,FIRST_NAME, POST,SALARY)VALUES( ' 1 ', ' AMRUT ', ' TH
INSERT INTO Update_STM ( id,name,
DOB,BORN_PALaCE)VALUES( ' 2 ', '
NEELA ', ' 01-01-1960 :14:50:23 ', '
THANLNER ') INSERT INTO INN_DEPT2(ID,FIRST_NAME, POST,SALARY)VALUES( ' 2 ', ' NEELA ', ' THA
INSERT INTO Update_STM ( id,name,
DOB,BORN_PALaCE)VALUES( ' 3 ', '
MUKESH ', ' 31-07-1984 : 10:54:20 ', '
THANLNER ') INSERT INTO INN_DEPT2(ID,FIRST_NAME, POST,SALARY)VALUES( ' 3 ', ' MUKESH ', ' T
INSERT INTO Update_STM ( id,name,
DOB,BORN_PALaCE)VALUES( ' 4 ', '
RAJSHREE ', ' 17-07-1987 : 04:12:30 ', '
JALGAON ') INSERT INTO INN_DEPT2(ID,FIRST_NAME, POST,SALARY)VALUES( ' 4 ', ' RAJSHREE ', '
INSERT INTO Update_STM ( id,name,
DOB,BORN_PALaCE)VALUES( ' 5 ', '
RAMA ', ' 08-11-2019 :11:45:12 ', '
JALGAON ') INSERT INTO INN_DEPT2(ID,FIRST_NAME, POST,SALARY)VALUES( ' 5 ', ' RAMA ', ' JALG
INSERT INTO Update_STM ( id,name,
DOB,BORN_PALaCE)VALUES( ' 6 ', '
ARIHANT ', ' 08-08-2023 : 07:45:12 ', '
CHOPDA ')
Jan-24
14 21 28
15 22 29
16 23 30
17 24 31
18 25 --
19 26 --
20 27 --
city
CHOPDA
PUNE
PUNE
PUNE
PUNE
PUNE
AGE
INSERT INTO
75 family1(ID,NAME,DEPT,AGE)VALUES('
1 ','AMRUT ','RETD ','75 ')
INSERT INTO
65 family1(ID,NAME,DEPT,AGE)VALUES('
2 ','NEELA ','HOME MAKER ','65 ')
INSERT INTO
38 family1(ID,NAME,DEPT,AGE)VALUES('
3 ','MUKESH ','JOB IT SECTOR ','38 ')
INSERT INTO
34 family1(ID,NAME,DEPT,AGE)VALUES('
4 ','RAJSHREE ','JOB TEACHER ','34 ')
INSERT INTO
4 family1(ID,NAME,DEPT,AGE)VALUES('
5 ','RAMA ','STUDENT ','4 ')
INSERT INTO
5 family1(ID,NAME,DEPT,AGE)VALUES('
6 ','ARIHANT ','CHILDHOOD ','5 ')
Sector
INSERT INTO
RETD famlily2(ID,NAME,SALARY,Sector)VAL
UES('1 ','AMRUT ','22000 ','RETD ')
INSERT INTO
JOB IT SECTOR famlily2(ID,NAME,SALARY,Sector)VAL
UES('3 ','MUKESH ','20000 ','JOB IT
SECTOR ')
INSERT INTO
JOB TEACHER famlily2(ID,NAME,SALARY,Sector)VAL
UES('4 ','RAJSHREE ','4000 ','JOB
TEACHER ')
INSERT INTO
STUDENT famlily2(ID,NAME,SALARY,Sector)VAL
UES('5 ','RAMA ','DEPENDENT
','STUDENT ')
INSERT INTO
CHILDHOOD famlily2(ID,NAME,SALARY,Sector)VAL
UES('6 ','ARIHANT ','DEPENDENT
','CHILDHOOD ')
VARCHAR (20),
VARCHAR (20),
EMP_CODE VARCHAR (2)
)
EMP_NAME INT PRIMARY KEY ,
EMP_LAST_NAME VARCHAR (20),
EMP_SALARY VARCHAR (20),
EMP_CODE VARCHAR (2)
MIDDLE_NAME,LAST_NAME,E_ADD)VALUES( ' 1 ', ' AMRUT ',' JAYRAM ',' WADE ', ' CHOPDA ')
MIDDLE_NAME,LAST_NAME,E_ADD)VALUES( ' 2 ', ' NEELA ',' AMRUT ',' WADE ', ' PUNE ')
MIDDLE_NAME,LAST_NAME,E_ADD)VALUES( ' 3 ', ' MUKESH ',' AMRUT ',' WADE ', ' PUNE ')
MIDDLE_NAME,LAST_NAME,E_ADD)VALUES( ' 4 ', ' RAJSHREE ',' MUKESH ',' WADE ', ' PUNE ')
MIDDLE_NAME,LAST_NAME,E_ADD)VALUES( ' 5 ', ' RAMA ',' MUKESH ',' WADE ', ' PUNE ')
MIDDLE_NAME,LAST_NAME,E_ADD)VALUES( ' 6 ', ' ANAND ',' MUKESH ',' WADE ', ' PUNE ')
MIDDLE_NAME,LAST_NAME,E_ADD)( ' 3 ', ', ', ', ' ')
ME, POST,SALARY)VALUES( ' 1 ', ' AMRUT ', ' THANLNER ', ' 01-01-1951- 12:10:12 ')
ME, POST,SALARY)VALUES( ' 2 ', ' NEELA ', ' THANLNER ', ' 01-01-1960 :14:50:23 ')
ME, POST,SALARY)VALUES( ' 3 ', ' MUKESH ', ' THANLNER ', ' 31-07-1984 : 10:54:20 ')
ME, POST,SALARY)VALUES( ' 4 ', ' RAJSHREE ', ' JALGAON ', ' 17-07-1987 : 04:12:30 ')
ME, POST,SALARY)VALUES( ' 5 ', ' RAMA ', ' JALGAON ', ' 08-11-2019 :11:45:12 ')
INSERT INTO
CALENDOR_JAN_2024(
SUN,MON,TUE,WED,TH
U,FRI,SAT)VALUES( '
SUN ',' 0 ', ' 7 ',' 14 ','
21 ',' 28 ')
INSERT INTO
CALENDOR_JAN_2024(
SUN,MON,TUE,WED,TH
U,FRI,SAT)VALUES( '
MON ',' 1 ', ' 8 ',' 15 ','
22 ',' 29 ')
INSERT INTO
CALENDOR_JAN_2024(
SUN,MON,TUE,WED,TH
U,FRI,SAT)VALUES( '
TUE ',' 2 ', ' 9 ',' 16 ',' 23
',' 30 ')
INSERT INTO
CALENDOR_JAN_2024(
SUN,MON,TUE,WED,TH
U,FRI,SAT)VALUES( '
WED ',' 3 ', ' 10 ',' 17 ','
24 ',' 31 ')
INSERT INTO
CALENDOR_JAN_2024(
SUN,MON,TUE,WED,TH
U,FRI,SAT)VALUES( '
THU ',' 4 ', ' 11 ',' 18 ','
25 ',' -- ')
INSERT INTO
CALENDOR_JAN_2024(
SUN,MON,TUE,WED,TH
U,FRI,SAT)VALUES( ' FRI
',' 5 ', ' 12 ',' 19 ',' 26 ','
-- ')
INSERT INTO
CALENDOR_JAN_2024(
SUN,MON,TUE,WED,TH
U,FRI,SAT)VALUES( '
SAT ',' 6 ', ' 13 ',' 20 ','
27 ',' -- ')
select * from STUDENT_OCT2022
CREATE TABLE STUDENT_OCT2022
(
STUDENT_Id int IDENTITY(1,1) PRIMARY KEY,
STUDENT_Class int NOT NULL UNIQUE,
First_Name varchar(50) NOT NULL,
Last_Name varchar(50) NOT NULL,
Area_Code int NULL,
S_Address varchar(50) NULL,
Phone varchar (50) NULL,
)
insert into STUDENT_OCT2022 (STUDENT_Id ,STUDENT_Class,First_Name,Last_Name,
Area_Code,S_Address, Phone )
values
(1,5,'Shorya','Devekar',28,12,'Hadpasar',12345) ;
VARCHAR (2)
ME,E_ADD)VALUES( ' 1 ', ' AMRUT ',' JAYRAM ',' WADE ', ' CHOPDA ')
ME,E_ADD)VALUES( ' 2 ', ' NEELA ',' AMRUT ',' WADE ', ' PUNE ')
ME,E_ADD)VALUES( ' 3 ', ' MUKESH ',' AMRUT ',' WADE ', ' PUNE ')
ME,E_ADD)VALUES( ' 4 ', ' RAJSHREE ',' MUKESH ',' WADE ', ' PUNE ')
ME,E_ADD)VALUES( ' 5 ', ' RAMA ',' MUKESH ',' WADE ', ' PUNE ')
ME,E_ADD)VALUES( ' 6 ', ' ANAND ',' MUKESH ',' WADE ', ' PUNE ')
ME,E_ADD)( ' 3 ', ', ', ', ' ')
ES( ' 1 ', ' AMRUT ', ' THANLNER ', ' 01-01-1951- 12:10:12 ')
ES( ' 2 ', ' NEELA ', ' THANLNER ', ' 01-01-1960 :14:50:23 ')
ES( ' 3 ', ' MUKESH ', ' THANLNER ', ' 31-07-1984 : 10:54:20 ')
ES( ' 4 ', ' RAJSHREE ', ' JALGAON ', ' 17-07-1987 : 04:12:30 ')
ES( ' 5 ', ' RAMA ', ' JALGAON ', ' 08-11-2019 :11:45:12 ')
Data Types, Primary-Foreign Keys & Constraints in SQL | SQL
ys & Constraints in SQL | SQL Tutorial In Hindi 2 Name(Rishabh Mishra)
NAME OF
SR NO DESCRIPATION USE TO
FORMULA
1 SUM : Adds up all the numbers in a range.
2 AVERAGE:
Calculates the average of a range of
numbers.
3 MAX: Returns the largest number in a range.
4 MIN : Returns the smallest number in a range.
5 COUNT
: Counts the number of cells in a range
containing numbers.
6 IF
: Returns one value if a condition is true
and another value if it's false.
8 HLOOKUP
: Similar to VLOOKUP but searches in a
horizontal table.
9 INDEX:
Returns the value of a cell in a specified
row and column of a range.
10 MATCH
: Searches for a specified value in a range
and returns its relative position.
11 CONCATENATE
: Combines text from multiple cells into
one cell.
14 RIGHT
: Returns a specified number of
characters from the end of a text string.
15 LEN
: Returns the length (number of
characters) in a text string.
16 DATE
: Creates a date value from year, month,
and day components.
17 NOW : Returns the current date and time.
18 TODAY : Returns the current date.
19 SUMIF:
Adds up all the numbers in a range that
meet a single criterion.
20 COUNTIF
: Counts the number of cells in a range
that meet a single criterion.
S/W Application
1
2
3
4
5
6
7
8
SYNATAX ALL = SING
ACTUL FORMULA RANGE
LEFT
AVERAGE(range)
AVVEREERER
max(range)
min(range)
count(range)
INDEX(array,
row_num,
[column_num])
1)rate: The interest rate for each period.
2)per: The period for which you
want to calculate the principal
payment.3 )nper: The total number
of payment periods. 4) pv: The
present value or the principal
amount of the loan or investment.
5) [fv] (optional): The future
value or a cash balance you want to
attain after the last payment. If
omitted, Excel assumes it is 0.6)
[type] (optional): This indicates
whether the payment is made at the
beginning or end of the period. Use
0 for end of the period (default)
or 1 for the beginning.
CUSTOMER SUPPORT/SERVICES.
Parent-Menu Child-Menus
Feture Details of Login
if Owner -Wings/ Bulding /Flat No/
Customer Login
Name/ Mob No. Nos Of Time Login.
1) Date 2) Time In
Service given Date Time
via App login SMS/ code Details
Admin (Main ) All details
Opertator one should be control
Data base generate
Reply to Customer 1)Call 2) SMS 3)
By Operator Done Work(Operate by Operator of custome ,
Email Services 4) whatsapps 5) App
Reply(Admin) Two way Communication)
to App
count 20
if 20
VLOOKUP function 20
CONCATENATE Mukesh
TEXT:
2) Formatting a Time:---> =TEXT(B1,
"hh:mm AM/PM").
TEXT:
3)----> Formatting a Number: =TEXT(C1,
"0")
30 40 30
Time
14:45 02:45 PM
Text
Error $#,##0.00
$#,##0.00
8668840489 489
8668840489 89
38
2/4/2024 15:17
88,000
10%
2
4,060.75
figures
1500000
10%
15
12,500
figures
1,500,000.00
10%
15
8,333
20,833
8,833
Column1 Column2 Column3 Column4 Column5 Column6
SUPPORT_PERS CALL_DURA
Tokan_id Date Time NAME_OF_CALLER
ON_NAME TION
1 07-04-2023 09:30:00 Sachin Govind (Barmer sec. control Room) 120 sec
1 min:
43 09-04-2023 18:45:00 Mukesh Laxman Service Engineer
55Sec
1 min:
44 09-04-2023 18:45:00 Mukesh Abhilash Diwan Sir .
12Sec
1 min, 42
45 10-04-2023 07:52:00 Mukesh Barmer Comtrol Room (Govind)
Sec
46 10-04-2023 08:40:00 Mukesh Laxman Service Engineer (Barmer) 22 min
49 10-04-2023 12:30:00 Mukesh Control Room Suvali- (Yash Patel) 1 min 12 sec
52 10-04-2023 16:22:00 Sachin Abhilash sir (IT HEAD vedanta) 1 min 32 sec
57 10-04-2023 18:26:00 Sachin Abhilash sir (IT HEAD vedanta) 3 min 13 sec
1 Min 12
79 12-04-2023 10:37:00 Mukesh Service Engg…. Barmer (Lumbaram)
Sec
1 Min 12
80 12-04-2023 11:37:00 Mukesh Service Engg…. Barmer (Lumbaram)
Sec
1 Min 12
81 12-04-2023 10:37:00 Mukesh Abhilash sir (IT HEAD Of vedanta)
Sec
1 Min 12
82 12-04-2023 10:37:00 Mukesh RTSO Passenger (BomaRam)
Sec
100 12-04-2023 18:33:00 Sachin Abhilash sir (IT HEAD Of vedanta) 3 min
121 15-04-2023 15:10:00 Mukesh Abhilash sir (IT HEAD Of vedanta) 1 min
Security Control Room Barmer
122 15-04-2023 15:52:00 Mukesh 1 Min
(Rakesh)
124 15-04-2023 17:31PM Mukesh Control Room Suvali (Abbas Ali) 2 min
03 min 17
138 17-04-2023 11:54:00 Sudhir Kunj Suvali
sec
01 min 22
155 18-04-2023 09:14:00 Sudhir Lumba Ram
sec
Security Control Room 02 min 44
156 18-04-2023 10:33:00 Sudhir
Barmer(Rakesh sec
01 min 36
176 19-04-2023 11:51:00 Sudhir Laxman Service engg.
sec
190 19-04-2023 18:00:00 Sachin Abhilash sir (IT HEAD Of vedanta) 2 min
191 19-04-2023 18:09:00 Sachin Abhilash sir (IT HEAD Of vedanta) 2 min
240 22-04-2023 16:57:00 Sudhir Abhilash sir (IT HEAD Of vedanta) 1 min
241 22-04-2023 17:14:00 Sudhir Abhilash sir (IT HEAD Of vedanta) 1 min
243 22-04-2023 17:29:00 Sudhir Abhilash sir (IT HEAD Of vedanta) 1 min
257 23-04-2023 16:50:00 Sachin Kuldeep sir (Crude security team) 1 min
258 23-04-2023 18:31:00 Sachin Kuldeep sir (Crude security team) 1 min
268 24-04-2023 16:48:00 Sachin Kuldeep sir (Crude security team) 1 min
269 24-04-2023 16:53:00 Sachin Kuldeep sir (Crude security team) 1 min
270 24-04-2023 17:08:00 Sachin Abhilash sir (IT HEAD Of vedanta) 2 min
278 25-04-2023 10:39:00 Sudhir Abhilash sir (IT HEAD Of vedanta) 1 min
312 26-04-2023 16:31:00 Sachin Kuldeep sir (Crude security team) 1 min
313 26-04-2023 17:46:00 Sachin Kuldeep sir (Crude security team) 1 min
314 26-04-2023 17:47:00 Sachin Kuldeep sir (Crude security team) 1 min
315 26-04-2023 17:47:00 Sachin Kuldeep sir (Crude security team) 1 min
317 26-04-2023 18:18:00 Sachin Kuldeep sir (Crude security team) 1 min
322 27-04-2023 10:04:00 Sudhir Abhilash sir (IT HEAD Of vedanta) 3 min
333 27-04-2023 16:45:00 Sachin Kuldeep sir (Crude security team) 1 min
334 27-04-2023 16:56:00 Sachin Kuldeep sir (Crude security team) 1 min
335 27-04-2023 17:01:00 Sachin Kuldeep sir (Crude security team) 1 min
350 28-04-2023 16:01:00 Sachin Abhilash sir (IT HEAD Of vedanta) 3 min
351 28-04-2023 16:22:00 Sachin Abhilash sir (IT HEAD Of vedanta) 1 min
352 28-04-2023 16:58:00 Sachin Abhilash sir (IT HEAD Of vedanta) 1 min
Call from Tanker installtion (tanker
353 28-04-2023 16:59:00 Sachin 2 min
Owner)
364 28-04-2023 17:05:00 Sachin Kuldeep sir (Crude security team) 1 min
365 28-04-2023 17:14:00 Sachin Kuldeep sir (Crude security team) 1 min
366 28-04-2023 17:18:00 Sachin Abhilash sir (IT HEAD Of vedanta) 3 min
372 29-04-2023 18:02:00 Mukesh Kuldeep sir (Crude security team) 1 min
373 30-04-2023 08:41:00 Mukesh Laxman Service engg. 1 min
376 30-04-2023 14:51:00 Sachin Kuldeep sir (Crude security team) 1 min
377 30-04-2023 17:16:00 Sachin Kuldeep sir (Crude security team) 1 min
378 30-04-2023 18:32:00 Sachin Laxman Service engg. 1 min
384 01-05-2023 15:35:00 Sachin Kuldeep sir (Crude security team) 1 min
385 01-05-2023 16:13:00 Sachin Kuldeep sir (Crude security team) 1 min
386 01-05-2023 16:15:00 Sachin Kuldeep sir (Crude security team) 1 min
387 01-05-2023 17:39:00 Sachin Kuldeep sir (Crude security team) 1 min
388 01-05-2023 17:32:00 Sachin Laxman Service engg. 3 min
389 02-05-2023 8:56Am Mukesh Govind (Barmer sec. control Room) 2 min
390 02-05-2023 9:18:00Am Mukesh Abas Ali (Suvali. control Room) 2 min
399 02-05-2023 17:27:00 Sachin Kuldeep sir (Crude security team) 3 min
403 02-05-2023 17:27:00 Sachin Kuldeep sir (Crude security team) 3 min
404 02-05-2023 18:42:00 Sachin Kuldeep sir (Crude security team) 1 min
405 02-05-2023 18:45:00 Sachin Kuldeep sir (Crude security team) 1 min
406 02-05-2023 18:45:00 Sachin Kuldeep sir (Crude security team) 1 min
407 02-05-2023 18:43:00 Sachin Laxman Service engg. 1 min
409 02-05-2023 19:31:00 Sachin Abhilash sir (IT HEAD Of vedanta) 3 min
415 03-05-2023 07:11:00 Sachin Kuldeep sir (Crude security team) 1 min
419 03-05-2023 16:19:00 Sudhir Kuldeep sir (Crude security team) 1 min
430 04-05-2023 15:10:00 Sudhir Kuldeep sir (Crude security team) 1 min
431 04-05-2023 15:48:00 Sudhir Kuldeep sir (Crude security team) 2 min
432 04-05-2023 16:16:00 Sudhir Kuldeep sir (Crude security team) 1 min
433 04-05-2023 16:19:00 Sudhir Kuldeep sir (Crude security team) 3 min
466 07-05-2023 16:08:00 Sachin Kuldeep sir (Crude security team) 1 min
467 07-05-2023 16:16:00 Sachin Laxman Service engg. 1 min
468 07-05-2023 17:37:00 Sachin Kuldeep sir (Crude security team) 1 min
469 07-05-2023 17:46:00 Sachin Kuldeep sir (Crude security team) 1 min
494 09-05-2023 09:49:00 Sachin Abhilash sir (IT HEAD Of vedanta) 2 min
500 09-05-2023 00:43:00 Sachin Abhilash sir (IT HEAD Of vedanta) 2 min
501 09-05-2023 13:09:00 Sachin Kuldeep sir (Crude security team) 1 min
502 09-05-2023 13:12:00 Sachin Kuldeep sir (Crude security team) 1 min
506 09-05-2023 15:04:00 Sudhir Abhilash sir (IT HEAD Of vedanta) 2 min
507 09-05-2023 15:09:00 Sudhir Abhilash sir (IT HEAD Of vedanta) 2 min
508 09-05-2023 15:35:00 Sudhir Kuldeep sir (Crude security team) 1 min
509 09-05-2023 15:42:00 Sudhir Kuldeep sir (Crude security team) 1 min
510 09-05-2023 15:43:00 Sudhir Kuldeep sir (Crude security team) 1 min
511 09-05-2023 16:42:00 Sudhir Kuldeep sir (Crude security team) 1 min
512 09-05-2023 16:45:00 Sudhir Kuldeep sir (Crude security team) 1 min
513 09-05-2023 16:46:00 Sudhir Kuldeep sir (Crude security team) 1 min
514 09-05-2023 16:49:00 Sudhir Abhilash sir (IT HEAD Of vedanta) 1 min
515 09-05-2023 16:53:00 Sudhir Abhilash sir (IT HEAD Of vedanta) 1 min
516 09-05-2023 16:55:00 Sudhir Abhilash sir (IT HEAD Of vedanta) 1 min
517 09-05-2023 16:58:00 Sudhir Abhilash sir (IT HEAD Of vedanta) 1 min
519 09-05-2023 17:21:00 Sudhir Kuldeep sir (Crude security team) 1 min
520 09-05-2023 17:22:00 Sudhir Kuldeep sir (Crude security team) 1 min
522 10-05-2023 10:27:00 Sachin Abhilash sir (IT HEAD Of vedanta) 4 min
531 10-05-2023 15:03:00 Sudhir Kuldeep sir (Crude security team) 1 min
532 10-05-2023 15:07:00 Sudhir Kuldeep sir (Crude security team) 1 min
533 10-05-2023 15:27:00 Sudhir Lumba Ram 1 min
539 10-05-2023 16:47:00 Sudhir Kuldeep sir (Crude security team) 1 min
540 10-05-2023 16:52:00 Sudhir Kuldeep sir (Crude security team) 2 min
541 10-05-2023 17:11:00 Sudhir Kuldeep sir (Crude security team) 1 min
550 11-05-2023 16:01:00 Sudhir Kuldeep sir (Crude security team) 1 min
552 11-05-2023 16:13:00 Sudhir Kuldeep sir (Crude security team) 1 min
553 11-05-2023 16:21:00 Sudhir Kuldeep sir (Crude security team) 1 min
554 11-05-2023 16:22:00 Sudhir Kuldeep sir (Crude security team) 1 min
556 11-05-2023 18:34:00 Sudhir Kuldeep sir (Crude security team) 2 min
557 11-05-2023 18:40:00 Sudhir Kuldeep sir (Crude security team) 1 min
558 11-05-2023 18:45:00 Sudhir Lumba Ram 1 min
566 12-05-2023 16:12:00 Sudhir Kuldeep sir (Crude security team) 1 min
567 12-05-2023 16:46:00 Sudhir Kuldeep sir (Crude security team) 1 min
568 13-05-2023 17:33:00 Sudhir Laxman Service engg. 1 min
569 12-05-2023 18:12:00 Sudhir Kuldeep sir (Crude security team) 1 min
571 13-05-2023 15:56:00 Mukesh Kuldeep sir (Crude security team) 1 min
575 13-05-2023 19:13:00 Mukesh Kuldeep sir (Crude security team) 1 min
579 14-05-2023 16:41:00 Sudhir Kuldeep sir (Crude security team) 1 min
580 14-05-2023 16:46:00 Sudhir Kuldeep sir (Crude security team) 1 min
581 14-05-2023 17:44:00 Sudhir Kuldeep sir (Crude security team) 1 min
589 15-05-2023 15:08:00 Sudhir Kuldeep sir (Crude security team) 1 min
590 15-05-2023 15:25:00 Sudhir Kuldeep sir (Crude security team) 1 min
591 15-05-2023 15:26:00 Sudhir Kuldeep sir (Crude security team) 1 min
592 15-05-2023 15:42:00 Sudhir Kuldeep sir (Crude security team) 1 min
593 15-05-2023 15:55:00 Sudhir Kuldeep sir (Crude security team) 2 min
594 15-05-2023 15:57:00 Sudhir Kuldeep sir (Crude security team) 1 min
595 15-05-2023 16:26:00 Sudhir Kuldeep sir (Crude security team) 5 min
596 15-05-2023 17:36:00 Sudhir Kuldeep sir (Crude security team) 1 min
597 15-05-2023 17:39:00 Sudhir Kuldeep sir (Crude security team) 1 min
598 15-05-2023 17:55:00 Sudhir Lumbaram Service engg. 1 min
601 16-05-2023 10:33:00 Mukesh Kuldeep sir (Crude security team) 12 min
602 16-05-2023 12:12:00 Mukesh RTSO Suvali (Abbas Ali Sir) 1Min
603 16-05-2023 14:36:00 Sudhir Kuldeep sir (Crude security team) 1 min
604 16-05-2023 15:46:00 Sudhir Kuldeep sir (Crude security team) 1 min
605 16-05-2023 17:09:00 Sudhir Kuldeep sir (Crude security team) 1 min
606 16-05-2023 17:09:00 Sudhir Kuldeep sir (Crude security team) 1 min
610 16-05-2023 18:51:00 Sudhir Kuldeep sir (Crude security team) 1 min
624 17-05-2023 15:22:00 Sudhir Kuldeep sir (Crude security team) 1 min
625 17-05-2023 16:21:00 Sudhir Kuldeep sir (Crude security team) 2 min
626 17-05-2023 16:46:00 Sudhir Kuldeep sir (Crude security team) 2 min
630 17-05-2023 17:09:00 Sudhir Kuldeep sir (Crude security team) 1 min
631 17-05-2023 17:13:00 Sudhir Kuldeep sir (Crude security team) 1 min
632 17-05-2023 17:17:00 Sudhir Kuldeep sir (Crude security team) 2 min
633 17-05-2023 17:33:00 Sudhir Laxman Service engg. 2 min
644 18-05-2023 15:22:00 Sudhir Kuldeep sir (Crude security team) 1 min
646 18-05-2023 17:11:00 Sudhir Kuldeep sir (Crude security team) 1 min