求助, SQL 这个应该怎么写啊, 求高手指教,谢谢
Using
concatenation operators display the department name and location for all
departments with a department id less or equal to 30.
Each row retrieved should resemble
the output format below. The template for the output format is:
The MARKETING department is located
in SEATTLE.
我是这样写的
SELECT ' "THE || DEPTNO || department is located in || LOC ||" '
FROM DEPT1
WHERE DEPTNO
|