银行的sql查询语句是什么样子的。？

1. update Customer_Balance set balance = balance - 200 where card_id = '77777777'
insert into BillingHistory(card_id, amount, billing_date) values ('77777777', -200, '2012-02-18')
2. update Customer_Balance set balance = balance - 300 where card_id = '77777777'
update Customer_Balance set balance = balance + 300 where card_id = '99999999'
insert into BillingHistory(card_id, amount, billing_date) values ('77777777', -300, '2012-02-19')

银行的估计是大型数据库DB2之类的.
语法嘛都差不多.

那家的sql语句基本都是一样的吧追问

select * from 表名 ？

这个好像听老师说查的很慢。

追答

都是和具体的业务相关的，不会有查询全部的数据，至少也的家索引，分页处理等等
SELECT * FROM
(
SELECT A.*, ROWNUM RN
FROM (SELECT * FROM STUDENT order by stuID desc) A
WHERE ROWNUM = 11
--分页方法二
--使用ROW_NUMBER()
select * from
(
select stuID,stuName,age ,ROW_NUMBER() OVER (ORDER BY stuID desc) RN
from Student
) NewData
where RN BETWEEN 11 AND 20
--分页方法三
--使用ROWNUM，ROWID
SELECT *
FROM STUDENT
WHERE ROWID IN (SELECT RID
FROM (SELECT ROWNUM RNO, ROWID RID
FROM (SELECT ROWID
FROM STUDENT
ORDER BY stuID desc)
WHERE ROWNUM = 11)
ORDER BY stuID desc

本回答被网友采纳