7 of 7
Paper No: 1
Results
Messages
(No column name)
1
4
Picture 8.1
Question 9:
[1] Write a query to delete all rows that have the serviceID = 12 in the table ServiceMehanic.
Results Messages
service TicketID serviceID
mechanicID
hours comment rate
26
30
31
22223323333
10111240
2
41051230031 2
NULL
2000000.00
27 10111240
7
41051230244 4
NULL
1650000.00
28 10111240
16
41051230041 1
NULL
1000000.00
29 10111241
3
41051230032 2
NULL
1800000.00
10111241
5
41051230026 2
NULL
2000000.00
10111241
11
41051230060 1
NULL
7600000.00
34
10111242
10111243
10111244
16
41051230158 5
NULL
3200000.00
13
41051230034 6
NULL
800000.00
3
41051230025 1
NULL
1800000.00
35 10111244
10
36 10111245
12
41051230142 2
41051230038 2
NULL
NULL
6500000.00
1000000.00
Picture 9.1
Question 10:
Zoom
[0.5] Create a function named f_tk. This function has an input parameter(@mechanicID
decimal(18,0)) and return a table. The retured table includes mechanicID, mechanicName,
100%
Close
