Visual FoxPro 在線急

1. list 職工號,姓名,出生日期 for 性別="女" and 婚否=.F.

2. list for 姓名="胡"

3. list for recno()>=2

4. repl all 工資 with 工資*1.1

5. repl 出生日期 with {^1950-10-06 } for 姓名="王愛民"

6. delete for 出生日期<{^1949-12-31}

7. recall all

8. select avg(工資) from zg where 性別="男"

select avg(工資) from zg where 性別="女"

9. go bottom

?recno()

10. select 職稱,sum(工資) from zg group by 職稱