亚信面试回忆

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

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)类型的题目，下次再做详述！