A. (10) Treatment of grab
In the online processing database, you often encounter a phenomenon of multiple customers grab, but these often can't avoid it in OLTP, ask what is good solution.
(Since the prefixed prefix is considered, the specific situation cannot be used in the specific case.
Tip: You can describe your processing plan with a variety of written methods such as graphics, build table, encoding.
[Database Case] (30)
B (20) Customer ABC Analysis
There is a customer ranking sales table T1, and the table content is as follows (1):
Table Structure: T1 (Client, CUR_MONEY
Schedule (1) XX Month Customer Rank Sales Table
client
name
Laundry
Amount
client
name
Laundry
Amount
Promptly
131,000
joint
18,000
Thinking
66,00
Fengxiang
17,000
Bamboo
54,000
Yuan Tai
17,000
Seven round
48,000
Departure
16,000
Taochang
44,000
Jinquan
16,000
Rich word
39,000
Jialiang
16,000
Lobby
37,000
Good home
15,000
East Asia
34,000
Dexing
15,000
Luxuriant
28,000
brand new
13,000
culture
28,000
Xiangde
11,000
Dongshi
27,000
Envoy
11,000
Comrade
27,000
Ruilong
10,000
Xinchang
26,000
central
10,000
Li Yuan
26,000
Become more
10,000
Issue
25,000
Benevolence
10,000
Renji
25,000
Yongchang
9,000
North Po
24,000
Three Tai
8,000
New light
22,000
Big
6,000
Jiao New
21,000
Peaceful
6,000
Trust
21,000
Cellular
6,000
Taichang
21,000
Vibration
5,000
Trusted
21,000
The following new table customer ABC analysis table T2, and the table content are as follows (2)
