Tag:bonus

  • C practical exercise topic 2

    Time:2021-2-23

    Title:The bonus paid by the enterprise is based on the profit commission. When the profit (I) is less than or equal to 100000 yuan, the bonus can be increased by 10%; When the profit is higher than 100000 yuan and lower than 200000 yuan, the part below 100000 yuan will be charged with 10% commission, […]

  • Writing SQL cases based on MySQL (1)

    Time:2021-2-15

    Database SQL file in the database: https://blog.csdn.net/GongmissYan/article/details/102937816 #Basic query /* Syntax: Select query list From table name; Query lists can be fields in tables, constant values, expressions, and functions The query table is a virtual table */ #Query single field select last_name from employees #Query multiple fields select last_name ,salary,email from employees #All fields in […]

  • OKR beginner’s Guide (Part 4)

    Time:2020-11-13

    Typical OKR system period The common OKR cycle is as follows: 1) At the beginning of the year, the company defined a set of advanced strategic OKR, preferably with the help of the team. It is important to understand that without team input, top management should not develop strategic okrs in isolation. Should his article […]

  • Oracle Basics – simple query exercise (1)

    Time:2020-9-27

    Practice based on the EMP table under Scott user in Oracle database Query all tables under Scott user select * from tabs; Query all information in employee table select * from emp; Query employee number, name, job, salary. select empno,ename,job,sal from emp; Check the type of employee’s job. select distinct job from emp; Query employee […]

  • Oracle Basics – simple query exercise (2)

    Time:2020-9-26

    Practice based on the employees table under HR user in Oracle database HR needs to get the name of the employee whose salary is more than $12000 a month (last_ Name) and salary report, please complete the query statement select last_name, salary from employees where salary >12000; HR needs to identify groups of high-income and […]

  • Oracle Basics – single line function exercise (2)

    Time:2020-9-21

    Oracle Basics – single line function exercise (2) Practice based on the employees table under HR user in Oracle database Query system current date select sysdate from dual; Please check each employee’s name, salary and salary after 15.5% increase (TRUNC round) Select last_name,salary,trunc(salary*1.155) “new salary” from employees; Displays the employee’s name, original salary, and increased […]

  • [pl / SQL] NVL, nvl2 and coalesce

    Time:2020-7-2

    After reading this chapter, you will learn the following: Their respective usage What’s different about them NVL function The functions of NVL (E1, E2) are as follows:If E1 is null, the function returns E2, otherwise it returns E1 itself Example: if the comm bonus on EMP table is null, replace it with 0 SELECT NVL(COMM,0) […]

  • Oracle foundation – simple query exercise (2)

    Time:2020-5-21

    Practice based on the employees table of HR user in Oracle Database HR needs to be paid more than $12000 a month (last_ Name) and salary report, please complete the query statement select last_name, salary from employees where salary >12000; HR needs to identify high-income and low-income employee groups. Please show the name and salary […]

  • Oracle foundation – single line function exercise (2)

    Time:2020-5-15

    Oracle foundation – single line function exercise (2) Practice based on the employment table of HR user in Oracle Database Query system current date select sysdate from dual; Please check each employee’s name, salary and salary after 15.5% increase (TRUNC rounding) Select last_name,salary,trunc(salary*1.155) “new salary” from employees; Displays the employee’s name, original salary, and increased […]

  • Aelf enterprise 0.8.0 beta has award public beta, and the “bug bonus plan” is launched

    Time:2019-12-17

    On September 30, 2019, the 0.8.0 beta version of aelf enterprise was officially released. Aelf enterprise 0.8.0 beta is a complete blockchain system, including a complete blockchain system, development kits, development documents, as well as supporting basic applications and basic services. Compared with the 0.8.0 alpha version of aelf enterprise, the 0.8.0 beta version of […]