Multiple choice

Select a query to display the highest and the lowest salary for all the employees.

Consider the following relation schema ..... EMP(ENAME,EMPNO,SAL,COMM,DEPTNO,JOB,MGR,HIREDATE)...

  1. select max(SAL), min(SAL) from EMP;

  2. select high(SAL), low(SAL) from EMP;

  3. select hi(SAL), lo(SAL) from EMP;

  4. select best(SAL), min(SAL) from EMP;

  5. none of these
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

We use max keyword to get the highest value and we use min keyword to get the lowest value.

Keep practicing — related questions