Steve Jones Johnson

View All Scripts Login to Run Script

Statement 1

CREATE TABLE people (first_name, last_name) AS
SELECT 'Steve', 'Jones Johnson' FROM dual UNION ALL
SELECT 'Steve Jones', 'Johnson' FROM dual

Table created.

Statement 2

SELECT first_name || ' ' || last_name, COUNT(*)
FROM people
GROUP BY first_name, last_name


FIRST_NAME||''||LAST_NAME COUNT(*)
Steve Jones Johnson 1
Steve Jones Johnson 1

2 rows selected.

FIRST_NAME\|\|''\|\|LAST_NAME	COUNT(*)
Steve Jones Johnson	1
Steve Jones Johnson	1

Statement 3

SELECT first_name || ' ' || last_name, COUNT(*)
FROM people
GROUP BY first_name || ' ' || last_name


FIRST_NAME||''||LAST_NAME COUNT(*)
Steve Jones Johnson 2

FIRST_NAME\|\|''\|\|LAST_NAME	COUNT(*)
Steve Jones Johnson	2

Additional Information