去亚信面试,才发现自己基础都忘光了,或者说都不会

linux出了一些简单的命令:

cat /proc/cupinfo linux下CPU信息

cat /proc/meminfo  linux下内存信息信息

Oracle出了一些查询:

学习于http://www.cnblogs.com/nvli/articles/2171194.html

1、查找表中多余的重复记录,重复记录是根据单个字段(peopleId)来判断

select *

from people

where peopleId in(select peopleId from people group by peopleId having count(peopleId)>1)

2、删除表中多余的重复记录,重复记录是根据单个字段(peopleId)来判断,只留有rowid最小的记录

delete from people

where peopleId in(select peopleId from people group by peopled having count(peopleId)>1)

and rowid not in(select min(rowid) from people group by peopleId having count(peopleId)>1)


c++还出了一个hello world的题目,是关于内存的

void GetMemory(char *p)类型的题目,下次再做详述!


Logo

更多推荐