Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

List the name and empno of managers who earn more than 2000.display the result in alphabetical order of the name. EMPNO ENAME 7369 SMITH 7499

  1. List the name and empno of managers who earn more than 2000.display the result in alphabetical order of the name.

EMPNO ENAME 7369 SMITH 7499 ALLEN 7521 WARD 7566 JONES 7654 MARTIN 7698 BLAKE 7782 CLARK 7788 SCOTT 7839 KING 7844 TURNER 7876 ADAMS 7900 JAMES 7902 FORD 7934 MILLER JOB CLERK SALESMAN SALESMAN MANAGER SALESMAN MANAGER MANAGER ANALYST PRESIDENT SALESMAN CLERK CLERK ANALYST CLERK MGR 7902 7698 7698 7839 7698 7839 7839 7566 7698 7788 7698 7566 7782 HIREDATE SAL 17-Dec-80 20-Feb-81 22-Feb-81 02-Apr-81 2975 28-Sep-81 1250 01-May-81 2850 09-Jun-81 09-Dec-82 17-Nov-81 08-Sep-81 12-Jan-83 03-Dec-81 03-Dec-81 23-Jan-82 800 1600 1250 2450 3000 5000 1500 1100 950 3000 1300 COMM 300 500 1400 0 DEPTNO 20 30 8888 30 20 30 30 10 20 10 30 20 30 20 10

Step by Step Solution

3.39 Rating (158 Votes )

There are 3 Steps involved in it

Step: 1

Solution Query SELE... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Concepts of Database Management

Authors: Philip J. Pratt, Mary Z. Last

8th edition

1285427106, 978-1285427102

More Books

Students also viewed these Databases questions

Question

What is Memory Addressing and Function Calls?

Answered: 1 week ago

Question

What are the characteristics of OLTP systems?

Answered: 1 week ago

Question

Describe the purpose of the JOIN command in relational algebra.

Answered: 1 week ago