--statistics on the sum of departments ' wages according to each departmentSelect DeptID, sum (SAL) payroll totals from the EMP group by DeptID;--statistics on the sum of departments ' wages according to each departmentSelect DeptID, Payroll total, SUM (payroll total) over () as TotalFrom (select DeptID, sum (SAL) payroll total from EMP Group by DeptID) x;SelectDeptID Department,Total wage,Total Sum,Round (Total payroll/total) * 100, 2) | | '% ' as wage ratioFrom (select DeptID,Total wage,SUM (p
Tags: Oracle--Delete the previously existing table:
drop table emp;
--Creating the Table EMP CREATE TABLE
emp
(
deptno number,
ename varchar2 (),
sal number
);
--Insert data-
-Department 1 Employee Information
INSERT INTO EMP values (1, ' Wang Hee 1 ', 15000);
INSERT into EMP values (1, ' King Hee 2 ', ");
INSERT into EMP values (1, ' King Hee 3 ', 115000);
INSERT into EMP values (1, ' King Hee 4 ', 12300);
--Department 2 employee information
INSERT INTO EMP values (2, ' Wang H
Concept 3: Make your employees proud
Companies with positive self-image and pride will be more unified and efficient, and have a stronger "employer brand ". Once employees respect and appreciate the company they work for, their efficiency, quality of the group, and job satisfaction will be improved.
ConceptAre your employees proud of your company's work? This
In the past few years, I have stayed in several companies, worked as new employees, and brought new employees. Some companies have done a good job in training new employees, some companies do not pay attention to training at all.
For example:
1) The company arranges time to familiarize itself with products, that is, to get started with the industry;2) Start B
The average age of Microsoft employees is about 30 years old, and most employees are quite young, especially for applications.ProgramDevelopers in the group. Half of all employees are directly from universities, and many Microsoft managers prefer this approach. They are willing to recruit young people because they are more likely to integrate into the "Microsoft
2013.6.16
1. Is the radish + stick invalid?Yes, the simple and easy-to-use incentive methods of radish + sticks can no longer meet the needs of IT industry team management. The possible causes are as follows:
1. Programmers are special peopleProgrammers are a group of intellectuals who like to laugh at themselves and are modest on the surface, but have the pursuit, persistence, and even a bit arrogant. While pursuing material happiness, we are also very concerned with our own sense of accomplish
have a negative effect and a huge lethal effect of 100% or even 200%. It can reduce a person's work enthusiasm and motivation to zero, or, ultimately, "nothing is done but not ".
Allowing employees to see the "Flying wood chips" in a timely manner can immediately mobilize their work enthusiasm and make their original boring and meaningless work attractive. For example, a blind factory in Shanghai specializes in producing various screws. This work is
as it does make a contribution, in addition to the very individual circumstances, Huawei will definitely give back to you, but may not be so timely.Performance is like a digital gameIn addition to science, in fact, from the above two sets of data can also be seen, Huawei employees pay income is divided into 3 parts: First, the salary, the second year-end award, three is the dividend, about 1/3 of the total. In terms of wages, the overall level is det
Four skills of managers:1. Select the right person;2. clarify expectations of employees;3. promptly praise employees for their outstanding performance;4. care about your employees.
An important cognition of management: recognizing the existence of individual differentiation.Outstanding managers know that even if employees
Edited by Anna Liu
Source: World Manager
Http://www.ceconline.com/ART_8800047630_110000_MA_01.HTM
Published on www.hr.comArticleThere are eight indications to learn whether your management style is recognized by employees.
First,Even if you are not in the office, your employees know what you expect them to do.. This means that you have made everyone understand your expectations for them and given the
Today, I saw an article about effective ways to develop employee potential at http://portal.vsharing.com/k/hr/2011-3/642875_1.html.
After carefully reading this article, the boss often finds that only one person in the meeting is explaining the monthly report and the current situation of the Department, and the Department plan for the next month, as well as the grand blueprint for the development of the Department. The employees below also nodded freq
There are many interesting topics about Google employees. Although everyone knows that Google's office allows dogs, other situations inside Google have always been mysterious. Last month, I wrote a new Googler experience in Google. This time it was my turn to ask for more information. Please note that I used double quotation marks to introduce "employee" in the title of this article, because Googler will be introduced below, although it looks like a r
The story of the Fisherman Snake FrogThe fisherman saw a snake on the side of the boat and a frog in his mouth. The fisherman moved his compassion and rescued the frog from the mouth of the snake. But the fisherman again for the snake will starve and sad, then took out a bottle of wine, to the mouth of the snake drops a few drops. The serpent swam happily, and the frog rejoiced to be reborn, and the fisherman was happy for his kindness. He thought, this is really happy! Unexpectedly, just a few
1. Set an example. An innovative company must start with its founding fathers and senior executives. Even the most creative founders cannot rely solely on their own power to drive innovation. It needs to be led by someone. Tell your employees with your own actions (not just verbal) to make innovation part of your daily life and let employees know that you value innovation very much.2. Recognize the target.
once. less often does anybody ask an equally important question: what makes a good employee?
Here are 10 of the qualities I find in the "best and brightest" employees, the people companies shoshould attract and retain.
If you have all of these attributes, you're probably a terriic employee.
First, it's important to have a fundamental curiosity about the product or products of your company or group. You have to use the products yourself.
This can't be
Original Chinese Text-good way to criticize employees
Check the intention of Criticism. Before criticizing employees, you must check your emotional status. Does the employee's mistake make you angry or betrayed? Is your mood forcing you to retaliate against this employee? If the answer is yes, please calm yourself down before talking to him.
[Kiki] This is often overlooked. I often call my subordinates for
Atitit. Corporate values employees first vs. Customer first. docx1. Customer First argument is wrong, employee priority is correct, philosophy and values 11.1. Any organization should have an organizational member priority greater than the external member well paid 11.2. the organization's largest resource is employee 21.3. an organization that has nothing in the economy, as long as there are a large number of members is power, such as medieval relig
Some employees in the organization may be weak employees, who are not very competent in business and have poor social relations. They seem to be unable to see you in the eyes of the boss, but they insist on doing this. If you change it, will it continue in this position? Professional stars, but very rare. If you are not a talented person, congratulations, because you have to go on the road of continuous ac
probability judgment for achieving a certain result and resulting in another series of results.
Uncertainty of results: the expectations of results are usually quite uncertain. Sometimes, the cause and result are so numerous that people are almost uncertain that a specific action will produce a specific result. Expectations depend entirely on the employee's perception of the connection between effort and outcome. There is a simple straightforward stimulus that often gets a better incentive effe
with the quickening pace of human life and production, the number of sub-healthy people has risen year by day. World Health Organization (W.H.O.The results of the survey showed that the world's disease state population accounted for20%, sub-health status of population accounted for75%, people who are really healthy only account for the total population.5%. The employees of enterprises or institutions, which undertake the important functions of industr
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.