Select dname from DEPT table where location is Islamabad. EMPNO ENAME 7369 SMITH 7499 ALLEN 7521 WARD
Fantastic news! We've Found the answer you've been seeking!
Question:
- Select dname from DEPT table where location is Islamabad.
Transcribed Image Text:
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 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
Expert Answer:
Related Book For
Posted Date:
Students also viewed these databases questions
-
Select three table values from Table 14 - 1 and verify them using the formula FV = (1+ R}N 1 R
-
Select three table values from Table 14-2 and verify them using the formula TV = R / (1 + R) N - 1
-
Select three table values from Table 14 - 3 and verify them using the formula TV = (1 + R) N - 1 / R(1 + R) N
-
Write a program MooresLaw that takes a command-line argument \(n\) and outputs the increase in processor speed over a decade if microprocessors double every \(n\) months. How much will processor...
-
You have been presented with the selected information taken from the financial statements of Southwest Airlines Co. shown on the next page. Note 8. Leases The majority of the Companys terminal...
-
In Example 30.8, we created a XML Query Data Model for the XML document of Figure 30.22(a). Now create an XML Query Data Model for the corresponding XML Schema of Figure 30.22(b).
-
You are presented with the following summarised information relating to Block plc for the year to 30 September 2008: Additional information: 1 Block purchased 80 per cent of the share capital of Chip...
-
Revenue Recognition on Book Sales with High Returns) Uddin Publishing Co. publishes college textbooks that are sold to bookstores on the following terms. Each title has a fixed wholesale price, terms...
-
If you own 5 SPX call options with a strike of 1950, what's the payoff at maturity for these option contracts if the S&P 500 index is at 1963? A. $0 B. $1,300 C. $5,000 D. $6,500 2. if...
-
For this exercise, your client, Bright IDEAS Inc., has provided you with a listing of sales invoices. To test whether the client appears to have a receivables collectability problem, the auditor must...
-
Paint Mixers Inc manufactures and sells a range of paints, including a high performance green paint that will attach to any surface without flaking or peeling. The purchasing manager is responsible...
-
Riki Co. acquires the entire share capital of Doom Co. by issuing 100,000 new P1 ordinary shares at a fair value at the acquisition date of P2.50. The professional fees associated with the...
-
use this noisy image then Write a code to keep only image edges Write a code to remove the noise from the image Write a code to keep only edges of the result from b) use java as a programing language...
-
What factors that have led to increased health care costs? what necessary skills that you would hope to possess in the potential role as a finance manager when making capital purchases and how this...
-
Make a Java class to find the difference between the sum of the cubes of the first one hundred natural numbers (1 to 100) and the cube of the sum of the first 100 natural numbers. You may use either...
-
Discuss what four steps should be implemented when developing a financial plan
-
write your commentary on the life of Freud and his theory . discuss at least four to five points (underline/highlight) from the video that you found most interesting and state why these points were...
-
On August 31, 2012, the balances of the accounts appearing in the ledger of Wood Interiors Company, a furniture wholesaler, are as follows:Prepare the August 31, 2012, closing entries for Wood...
-
True or false: For a budget spent entirely on two goods, an increase in the price of one will necessarily decrease the consumption of both, unless at least one of the goods is inferior. Explain.
-
The market demand curve for a pair of Cournot duopolists is given as P = 36 - 3Q, where Q = Q1 + Q2. The constant per unit marginal cost is 18 for each duopolist. Find the Cournot equilibrium price,...
-
Professors Adams and Brown make up the entire demand side of the market for summer research assistants in the economics department. If Adamss demand curve is P = 50 - 2QA and Browns is P = 50 - Q B ,...
-
Question: Martin, a diamond wholesaler, writes Serge, a jewelry retailer, offering to sell 75 specified diamonds for $2 million. Martin's offer sheet specifies the price, quantity, date of delivery,...
-
Question: To satisfy the UCC statute of frauds regarding the sale of goods, which of the following must generally be in writing? a. Designation of the parties as buyer and seller b. Delivery terms c....
-
Question: Warm, Inc. sells large, portable space heaters for industrial use. Warm sells Little Factory a unit and installs it. The sales contract states, "This heating unit is sold as is. There are...
Study smarter with the SolutionInn App