Selected more than 1750 yuan in wages and bonuses at 680 yuan below the teachers, how screen …
Names of the gender wage job total prize money
Pak Ming M 1600 540 2140
lecturer Li Lin, an associate professor of women 1780 680 2460
Zhao Jie, an associate professor M 1820 760 2580
Professor Wang Dongnan 1900 840 2740
Liu M 1650 460 Lecturer 2110
Professor Huang Junnv 1960 650 2610
GUO Long, an associate professor M 1850 500 2350
Zhang female lecturer 1580 400 1980
Using EXCEL spreadsheet
some
bring their own system which is used OFFICE-OFFICE EXCEL on the line, very good use of all of them imported into the Excel spreadsheet, select the “pay” and “bonus” cell , Click data – filter – automatic selection., Click on the “wages” on the button – custom, the election “more than” the right of the input 1750.At the same time, in “bonuses” to enter the same way, choose ” In the “right of the input 680.Finally, you want to be able to arrive at the results of one, if WORD or EXCEL spreadsheet, you can sort of data — Method.Keywords of the main election wages, according to the order from high to low, Secondary keyword election funds, according to the order from small to large.On the results of the out.
Second, if the database is, to use SELECT statement as follows:select * from table name where wage data> 1750 and prize money <600.The results are also seeking out.Professor of wages so low, how the money was
ah …
ah what the political arena can be used FOXBAS database
Leave a Reply
You must be logged in to post a comment.