Tag: databases

SELECT dept_id, job_cat, MAX(salary) FROM employees WHERE salary > MAX(salary);

SELECT dept_id, job_cat, MAX(salary) FROM employees GROUP BY dept_id, job_cat;

SELECT dept_id, job_cat, MAX(salary) FROM employees;

SELECT dept_id, job_cat, MAX(salary) FROM employees GROUP BY dept_id;

SUM(start_date)

COUNT(start_date)

AVG(start_date, end_date)

MIN(start_date)

Immediately after the SELECT clause

After the ORDER BY clause

After the WHERE clause

Before the WHERE clause

SELECT SUBSTR( ‘Hello World’,1) FROM dual;

SELECT INITCAP(TRIM (‘Hello World’, 1,1)) FROM dual;

SELECT LOWER(TRIM (‘H’ FROM ‘Hello World’)) FROM dual;

SELECT LOWER(SUBSTR(‘Hello World’, 2, 1) FROM dual;

SELECT ename, salary*12 ‘Annual Salary’ FROM employees;

SELECT ename, salary*12 “Annual Salary” FROM employees;

SELECT ename, salary*12 AS Annual Salary FROM employees;

SELECT ename, salary*12 AS INITCAP(“ANNUAL SALARY”) FROM employees

ORDER BY SALARY > 5000

GROUP BY SALARY > 5000

HAVING SALARY > 5000

WHERE SALARY > 5000

MAX

MIN

SUM

TOTAL

SELECT TO_CHAR(SYSDATE,'yyyy') FROM dual;

SELECT TO_DATE(SYSDATE,'yyyy') FROM dual;

SELECT DECODE(SUBSTR(SYSDATE, 8), 'YYYY') FROM dual;

SELECT DECODE(SUBSTR(SYSDATE, 8), 'year') FROM dual;

You want to identify the most senior employee in the company.

You want to find the manager supervising the largest number of employees

You want to identify the person who makes the highest salary for all employees.

You want to rank the top three sales representatives who have sold the maximum

46 and 45

46 and 45.93

50 and 45.93

50 and 45.9