oracle 数据库中以下几个题的sql语句

1\SELECT TO_CHAR(REGISTER, 'YYYYMM') AS MONTH, COUNT() FROM A GROUP BY TO_CHAR(REGISTER, 'YYYYMM');
2\SELECT COUNT() FROM (SELECT NAME FROM A GROUP BY NAME HAVING COUNT() > 1);
3\INSERT INTO C
SELECT AID, ANAME
FROM A
INNER JOIN (SELECT NAME FROM A GROUP BY NAME HAVING COUNT() > 1) B ON ANAME = BNAME;
4\SELECT MAX(REGISTER), ID, NAME
FROM A
GROUP BY ID, NAME;

以上就是关于oracle 数据库中以下几个题的sql语句全部的内容，包括:oracle 数据库中以下几个题的sql语句、、等相关内容解答，如果想了解更多相关内容，可以关注我们，你们的支持是我们更新的动力！