| |
|
|
| |
SELECT id, aah, adress, npatak, suma, data, tip,
CASE WHEN suma < 1001 THEN 50 ELSE CASE WHEN suma < 10001 THEN 100 ELSE CASE WHEN suma < 50001 THEN 150 ELSE CASE WHEN suma < 200001 THEN
250 ELSE CASE WHEN suma < 1000001 THEN 350 ELSE 500 END END END END END AS tax, 1 AS cod
FROM pv
|
Вход поля
id, aah, adress, npatak, suma, data, tip, tax, id1 ,suma1
как обяснить id1, suma1  | |
| |
|
