Tag:salary

  • Summary of common SQL statements in MySQL foundation 1

    Time:2021-1-27

    Database and table operation Create, delete and view databases create database mysql1 charset utf8; drop database mysql1; show databases; use mysql1; Create, delete and view tables create table mytab( id int primary key auto_increment, name varchar(50), gender varchar(10) not null, date date, ); //View table structure desc mytab; drop table mytab; Add, update and delete […]

  • Learning concerns: the future of learning C + +

    Time:2021-1-26

    Many friends have such a question, learning C / + + can do? What are the benefits? How about salary? Let’s answer it! As mentioned in the previous article, computer major ranks first among the popular majors. What’s the prospect. C language c + + is a high-level language, suitable for human writing, now the […]

  • [SQL] data De duplication partition or group by?

    Time:2021-1-17

    For the use of distinct and group by:1. When the performance of the system is high and the amount of data is large, group by is used2. When the performance of the system is not high and the amount of data used is small, both can be used3. Try to use group by Simple example: […]

  • Also programmers, why is the pay gap so big?

    Time:2021-1-13

    Recently, I often visit the professional speech area. It’s true that the legendary one million people per capita live up to their reputation. However, some of the offer Posts still reveal the wealth code of the programmer’s high salary. Why is the same programmer, but the salary is so poor? Why can a fresh student […]

  • Common basic statements of MySQL 2

    Time:2021-1-3

    Subquery exercise db40 List all employees whose salary is higher than Wang Haitao’s, and display their name and salary Select name, Sal from EMP where Sal > (select Sal from EMP where name = “Wang Haitao”); List all employees in the same position as Liu peixia, showing their names and positions. Select name, job from […]

  • When are you ready to change jobs for IOS development?

    Time:2020-11-20

    preface I believe many people are saying that the IOS industry is not good. The market of IOS is becoming more and more difficult. There are more unemployed people than people looking for jobs. Unemployment is equivalent to changing jobs, and job hopping is equivalent to lowering one’s own value. So do you IOS development, […]

  • Multi table query of Oracle Foundation (4)

    Time:2020-11-7

    Department name of the Department where all employees belongselect last_name,namefrom s_emp,s_dept; S1 table (ID, name)  Table S1 id name 1 s 2 a 3 b                   S2 table (ID, age) S2 table id name 1 s 2 a 3 b               […]

  • As programmers, why is the pay gap so big?

    Time:2020-10-28

    Recently, I often visit the workplace area. It is said that millions of people per capita are worthy of their reputation. However, some offer Posts still reveal the wealth password of high salary programmers. Why is the same programmer, but pay so much worse? Why can a new student be offered by several big factories […]

  • Five questions to be asked in software testing interview

    Time:2020-10-27

    The easiest and easiest way to step on thunder!!! See you again~ Found in the work found that the people around me is really the strength of the more efforts, the highest level of self-discipline, enjoy loneliness. (the article is a little long. You can read it according to your own needs. After all, people’s […]

  • well! When are you ready to change jobs for IOS development?

    Time:2020-9-30

    preface I believe many people are saying that the IOS industry is not good. The market of IOS is becoming more and more difficult. There are more unemployed people than people looking for jobs. Unemployment is equivalent to changing jobs, and job hopping is equivalent to lowering one’s own value. So do you IOS development, […]

  • 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 […]

  • Common commands of MySQL database

    Time:2020-9-22

    The basic SQL statements include select, insert, update, delete, create, drop, grant, revoke, etc     Library operations Create database: create database shujuku;Create database with character set of database;Create database with verification: create database mydb3 character set = utf8 collate utf8_ general_ CI;Display databases: show databases;Delete database: drop database shujuku;Modify the database code: alter databasese […]