Question

关于mysql count函数嵌套查询的问题？

SELECT COUNT(id) AS totalCount FROM （SELECT * FROM travel_cost WHERE 1=1） 请问这句画哪里错了





Answer 1

SELECT TYPENUMBER
FROM WZTYPE
WHERE TYPENUMBER LIKE CONCAT ((SELECT TYPENUMBER FROM WZTYPE WHERE TYPEID=12),''李闷改罩嫌____'哪判')
ORDER BY TYPEID DESC;