类型：转载 责任编辑：asp.net 日期：2007/05/23
热门软件下载：
SELECT p, xx, qjbh, uh, ulk, un, un1, s, f, f1, DRange = CASE WHEN xx IN (1, 2, 3, 4)
THEN ROUND(20 * log (CAST(p AS float) / CAST(f AS float)), 2) WHEN xx IN (5, 6, 7,
8) THEN ROUND(20 * log (CAST(p AS float) / CAST(f AS float))
+ 20 * log (CAST(un AS float) / CAST(uh AS float)), 2) END
FROM csjl3
WHERE (qjbh = 1111)
ORDER BY xx
我想问问怎么转换，case对应ACCESS的SQL，log对应ACCESS的SQL？CAST对应ACCESS的SQL？
网友回答：