hii this is me wellcom to my fresh & a interesting blogg first heartfelt Thanks guys for lot-of, love making my last blogg and i hope you like this nature blogg, without any delay let's get started:
In may 02 Sunday me & my friend got a planed to find nature created waterfall in such of it two ✌ friend was starting searching nature camp in uesing digita way like map 🗺 and finally he got a mother natural forest in kendujhar district the name was salandi reserve forest the forest was know as the the HADAGHARA DAM it covered 193km area,
in my opinion or friend review that the place good for summer vacations best view time (5:00 AM)to(8:30Am) or (4:30pm)to(7:00pm)
HADAGHRA DAM
it situated on salandi rivers it length was 980 meter it surround by the beautiful jungle and others in it was a eye catching places for tourist and great place for family picnic
5 Comments
select first_name,last_name,salary,department_id from employees
ReplyDeleteselect department_id from employees
select distinct department_id from employees
select * from employees where salary>10000
select * from employees where salary>=10000
select * from employees where salary<10000
select * from employees where salary<=10000
select * from employees where salary<>10000
select * from employees where salary=10000
select * from employees where last_name='King'
select * from employees
select * from employees where department_id > ANY(90,100)
select * from employees where email='SKING'
select * from employees where salary> any(4000,6000,11000)
select * from employees where salary> all(4000,6000,11000)
select * from employees where salary in(4100,9500,17000,24000)
select * from employees where first_name in('Steven','Neena')
select * from employees where salary between 10000 and 24000
select * from employees where hire_date between '12-aug-1987' and '01-jan-2000'
select * from employees where first_name like 'Sh%'
select * from employees where first_name like '%s'
select * from employees where salary>=5000 and hire_date>= '01-jan-2000'
ReplyDeleteselect * from employees where salary>=5000 and job_id='SA_MAN'
select employee_id , first_name , salary + commission_pct * salary from employees
select employee_id, first_name ,salary, salary * 0.1 as "HRA" from employees
select * from employees where hire_date<='01-jan-2020'
select * from employees order by salary
select * from employees order by salary desc
select distinct job_id from employees
select employee_id, commission_pct from employees where commission_pct is not null
"EMPLOYEE_ID","FIRST_NAME","LAST_NAME","EMAIL","PHONE_NUMBER","HIRE_DATE","JOB_ID","SALARY","COMMISSION_PCT","MANAGER_ID","DEPARTMENT_ID"
ReplyDelete"EMPLOYEE_ID","FIRST_NAME","LAST_NAME","EMAIL","PHONE_NUMBER","HIRE_DATE","JOB_ID","SALARY","COMMISSION_PCT","MANAGER_ID","DEPARTMENT_ID"
ReplyDelete"174","Ellen","Abel","EABEL","011.44.1644.429267","11-MAY-96","SA_REP","11000",".3","149","80"
"175","Alyssa","Hutton","AHUTTON","011.44.1644.429266","19-MAR-97","SA_REP","8800",".25","149","80"
"176","Jonathon","Taylor","JTAYLOR","011.44.1644.429265","24-MAR-98","SA_REP","8600",".2","149","80"
"177","Jack","Livingston","JLIVINGS","011.44.1644.429264","23-APR-98","SA_REP","8400",".2","149","80"
"178","Kimberely","Grant","KGRANT","011.44.1644.429263","24-MAY-99","SA_REP","7000",".15","149",""
"179","Charles","Johnson","CJOHNSON","011.44.1644.429262","04-JAN-00","SA_REP","6200",".1","149","80"
"180","Winston","Taylor","WTAYLOR","650.507.9876","24-JAN-98","SH_CLERK","3200","","120","50"
"181","Jean","Fleaur","JFLEAUR","650.507.9877","23-FEB-98","SH_CLERK","3100","","120","50"
"182","Martha","Sullivan","MSULLIVA","650.507.9878","21-JUN-99","SH_CLERK","2500","","120","50"
"183","Girard","Geoni","GGEONI","650.507.9879","03-FEB-00","SH_CLERK","2800","","120","50"
"184","Nandita","Sarchand","NSARCHAN","650.509.1876","27-JAN-96","SH_CLERK","4200","","121","50"
"185","Alexis","Bull","ABULL","650.509.2876","20-FEB-97","SH_CLERK","4100","","121","50"
"186","Julia","Dellinger","JDELLING","650.509.3876","24-JUN-98","SH_CLERK","3400","","121","50"
"187","Anthony","Cabrio","ACABRIO","650.509.4876","07-FEB-99","SH_CLERK","3000","","121","50"
"188","Kelly","Chung","KCHUNG","650.505.1876","14-JUN-97","SH_CLERK","3800","","122","50"
"189","Jennifer","Dilly","JDILLY","650.505.2876","13-AUG-97","SH_CLERK","3600","","122","50"
"190","Timothy","Gates","TGATES","650.505.3876","11-JUL-98","SH_CLERK","2900","","122","50"
"191","Randall","Perkins","RPERKINS","650.505.4876","19-DEC-99","SH_CLERK","2500","","122","50"
"192","Sarah","Bell","SBELL","650.501.1876","04-FEB-96","SH_CLERK","4000","","123","50"
"193","Britney","Everett","BEVERETT","650.501.2876","03-MAR-97","SH_CLERK","3900","","123","50"
"194","Samuel","McCain","SMCCAIN","650.501.3876","01-JUL-98","SH_CLERK","3200","","123","50"
"195","Vance","Jones","VJONES","650.501.4876","17-MAR-99","SH_CLERK","2800","","123","50"
"196","Alana","Walsh","AWALSH","650.507.9811","24-APR-98","SH_CLERK","3100","","124","50"
"197","Kevin","Feeney","KFEENEY","650.507.9822","23-MAY-98","SH_CLERK","3000","","124","50"
"198","Donald","OConnell","DOCONNEL","650.507.9833","21-JUN-99","SH_CLERK","2600","","124","50"
"199","Douglas","Grant","DGRANT","650.507.9844","13-JAN-00","SH_CLERK","2600","","124","50"
"200","Jennifer","Whalen","JWHALEN","515.123.4444","17-SEP-87","AD_ASST","4400","","101","10"
"201","Michael","Hartstein","MHARTSTE","515.123.5555","17-FEB-96","MK_MAN","13000","","100","20"
"202","Pat","Fay","PFAY","603.123.6666","17-AUG-97","MK_REP","6000","","201","20"
"203","Susan","Mavris","SMAVRIS","515.123.7777","07-JUN-94","HR_REP","6500","","101","40"
"204","Hermann","Baer","HBAER","515.123.8888","07-JUN-94","PR_REP","10000","","101","70"
"205","Shelley","Higgins","SHIGGINS","515.123.8080","07-JUN-94","AC_MGR","12000","","101","110"
"206","William","Gietz","WGIETZ","515.123.8181","07-JUN-94","AC_ACCOUNT","8300","","205","110"
select * from employees
ReplyDeleteselect distinct department_id from employees
select last_name , salary , commission_pct from employees where commission_pct =.2
select first_name,department_id, salary * 0.15 as "TA", salary * 0.4 as "DA", salary * 0.32 as "HRA", salary * (0.87) + salary as "GROSS SALARY" from employees
select last_name,job_id from employees where manager_id is not null
select first_name , last_name , department_id, salary,commission_pct from employees where commission_pct is not null order by salary
select last_name,department_id from employees where department_id in (30,50) order by last_name
select last_name, department_id, job_id, hire_date from employees where hire_date>'20-feb-1998' and hire_date<'01-june-1999'
select last_name from employees where first_name like '_a%'
select last_name from employees where last_name like '%i%' and last_name like '%o%'
select first_name,hire_date from employees where hire_date>='01-jan-1999' and hire_date<='31-dec-1999'