Create a query that will display the total no.of employees and, of that total, the no.of employees hired in 1995,1996,1997, and 1998. create appropriate column headings.
Create a matrix query to display the job, the salary for that job based on department number and the total salary for that job, for departments 20,50,80, and 90,giving each column and appropriate heading.
Create a query that will display the total no.of employees and, of that total, the no.of employees hired in 1995,1996,1997, and 1998. create appropriate column headings.
Write a query that displays the difference between the highest and lowest salaries. Label the column DIFFERENCE.
Latest Answer: SELECT job, count(*) AS no.ofemployee FROM emp GROUP BY job; ...
Create a query that display the last name,hire date and the day of the week on which the employee started. Label the column DAY. Order the results by the day of the week starting with Monday.LAST_NAME HIRE_DATE DAYGrant 24-MAY-99 MONDAYErnst 21-MAY-99 TUESDAYMourgos 16-NOV-99 TUESDAY------- ----- SUNDAY
I want to try create the database from my script which i made.can help me how to run a script. can explain me step by step because i am a starter.thank's
Latest Answer: Database snapshot is a read-only view of a database. It is taken from the source database and resides on the same server as the database. A snapshot uses a sparse file to store original pages from the source database. A sparse file is empty when a snapshot ...
Latest Answer: rownum is the temp num assigned for the return rows per statement queryIt will change as per the query statement.
It can be used with "=1" or "< 10" id number .Where as rowid is the id assigned by the
Oracle while creating record in database. It ...
Variable portionThe variable portion is called variable because its size (measured in bytes) can be changed. The variable portion consists of: • large pool (optional)Provides working space for rman
Latest Answer: In SGA, variable size is combination of shared pool, Java pool and Large PoolSQL> show sga;Total System Global Area 612368384 bytesFixed Size ...
View page << Previous 1 2 [3] 4 5 Next >>
Go Top
