SELECT in DATABASE

Here I will explain how to make a SELECT in the database.

        1.  SELECT e.last_name, e.departement_id,
           d.departement_name
           FROM tbemployee e, tbdepartement d
          WHERE e.departement_id = d.departement_id;  

2. SELECT DISTINCT job_id, location_id
FROM tbemployee, tbdepartement
WHERE tbemployee.departement_id =
tbdepartement.departement_id
AND tbemployee.departement_id = 80;

3. SELECT e.last_name, d.departement_name,
d.location_id, l.city
FROM tbemployee e, tbdepartement d, tblocation l
WHERE e.departement_id = d.departement_id
AND d.location_id = l.location_id
AND e.commision IS NOT NULL;

4   







     4. SELECT last_name, departement_name

FROM tbemployee, tbdepartement
WHERE tbemployee.departement_id =
tbdepartement.departement_id
AND last_name LIKE '%a%';

5. SELECT e.last_name, e.job_id,
e.departement_id, d.departement_name
FROM tbemployee e JOIN tbdepartement d
ON (e.departement_id = d.departement_id)
JOIN tblocation l
ON (d.location_id = l.location_id)
WHERE LOWER(l.city) = 'toronto';

6. SELECT employee_id, first_name,last_name,salary*12
FROM tbemployee
WHERE departement_id = 60 or departement_id = 90;

7. SELECT e.employee_id, e.first_name, e.last_name, e.salary*12
FROM tbemployee e, tbdepartement d
WHERE e.departement_id = d.departement_id
AND LOWER(d.departement_name) = 'it';

8. SELECT d.departement_id, (

SELECT AVG(salary*12)

FROM tbemployee e
WHERE e.departement_id = d.departement_id)
FROM tbdepartement d;

                                                              

9. SELECT e.employee_id, e.last_name,e.salary,

d.departement_name, l.city, l.country_id
FROM tbemployee e JOIN tbdepartement d
ON (e.departement_id = d.departement_id)
JOIN tblocation l
ON (d.location_id = l.location_id)
WHERE LOWER(l.city) = 'toronto';

10.  CREATE TABLE tbemployee2 AS (
SELECT e.employee_id, e.first_name, e.last_name,e.email,e.phone_number,e.hire_date,e.job_id, e.salary, e.commision, e.manager_id, e.departement_id, e.address
FROM tbemployee e, tbdepartement d
WHERE e.departement_id = d.departement_id
AND LOWER( d.departement_name ) = 'it');

I Already example of how to use SELECT in database.

And the results are listed along with the script.

»»  READMORE...

7 Amazing Jain Temple in India

7 Amazing Jain Temple in India

Jainism (Jainism / Jain) is an old religion in India origin side by side with Hindus. Some semblance of Jainism and Hindu teachings lead to the assumption that religion is one of the sects of Hinduism.

The fundamental difference between Jainism and Hinduism looks at Astika and Nastika. Schools in India divided on 2 principles. That principle holds Astika accept the authority of the Vedas as the scriptural beliefs and involve Brahmani. Nyaya, Mimamsa, and Yoga including Astika based teachings, and means Hindu groups.

While schools are principled Nastika reject the Vedas and scriptures used by Hindus. More basing Jainism their non-violent beliefs.

Mahatma Gandhi was a great man who adopted many teachings Jainsime like: Ahimsa (non-violence), Satya (honesty), Asteya (not stealing), Brahmacharya (mind control), and Aparigraha (not pursue worldly possessions). However, there is no concrete evidence whether Gandhi or Hindu followers of Jainism.

Currently, there were about 4.2 million followers of Jainism in India alone. While including the religious minorities, they have many beautiful temples as seen below:

1. Lal Mandir

Drawn Shri Lal Jain Mandir is the oldest temple of Jainism in India. Built in 1526, and experienced a lot of growth, especially since the 19th century. This temple of red sandstone material.

2. Sonagiri

Sonagiri Temple situated on a hill top town of Sonagiri (meaning: gold peak). The pilgrims and tourists who visit are required to climb 300 stairs in bare feet.

3. Khajuraho Jain

Khajuraho village is one of the most popular tourist destinations in India. In this village there are many temples for Hindus and Jainism which had stood since the year 950 to 1150 AD

4. Gomateshwara

At the top of the hill there is a statue of Shravanabelagola town Gomateshwara, he was the second son of the god Adinatha, the first of the 24 people on earth who "enlightened" (Tirthankara). 17.38 meters high, built around the year 983 AD by Chavundaraya, minister of the Kingdom of the Ganges.

Once every 12 years Mahamastakabhisheka festival held in this place. Namely bathe Gomateshwara statue with milk, saffron and gold coins.

5. Dilwara

Dilwara temple complex is so beautiful because it is made of marble. Carvings are so detailed and looks at the ceiling, doors, and pillars of the temple. There are five Jain temples here, each with a unique identity and is named after the small village where it is located. All the temples built by Chalukya dynasty between the 11th and 13th centuries.

6. Palitana

Palitana town is a major pilgrimage center for the followers of Jain. The temples of Palitana is considered the most sacred pilgrimage place in Jainism. There are hundreds of Jain temples situated on the holy mountain Shatrunjaya, beautifully engraved in marble. Built by Jain followers generations for 900 years, since the 11th century.

7. Ranakpur

Dedicated to Adinatha, Ranakpur Jain Temple looks magnificent on the hillside. There are over 1444 marble pillars in the temple, and all very beautiful carved.

The construction of this temple symbolizes the Tirthankara conquest of the four cardinal directions. There is still much debate about Ranakpur development time, but it was probably built between the 14th and mid-15th century AD.

That's what I'm talking about little temples in India Images.

»»  READMORE...