sql 语句

1.统计消费记录中的收入与支出

select sum(case when  Amount> 0 then Amount else 0 end) as c0, 
sum(case when Amount <0 then Amount else 0 end ) as c1 from Orders

 其它

DBCC CHECKIDENT ('merchants', RESEED, 0);

 

 

Oracle

---

 

1. 版本信息

select * from v$version

 

---

cmd命令

1.netstat －ano 查看端口号，由小到大排列