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 查看端口号，由小到大排列