0
How do you get the highest pay employee in an oracle database?
Wiki User
∙ 13y ago
Select employee, max(salary)
From employee
Group by employee
Order by one DESC
The employee with the max salary will be the first one reported.
Another way would be to use a analytical rank function.
Wiki User
∙ 13y ago
Add your answer:
Earn +20 pts
How do you create software in oracle?
Install oracle. Design your database for your requirements. ex: If you want to implement a payroll soltion for a company then you you may have to consider creating tables like employee personal details, Employee employment data, employee pay details, Employee other benefits etc. Create tables, view, procedures etc. Populate tables with actual data. Develop User interface for your application. Provide roles and privileges to represent actual usage of the application. Ofcourse, you may have to create a login page etc. Connect your application to talk to database. Run your application and use the implemented functionality
Can word processor create a database?
No. A database is much more complex then a document. You need a database program to create a database. If your needs are not too complex, Microsoft Access is a decent low end database. If you need something powerful, Oracle is much better, but you'll pay for it.
What is a field called in a physical database?
A field in database is the column of the table. In fields or columns we store the attributes. Example for a table employee we can have fields like Name, Last Name , Contact, Basic pay etc.
P to p in oracle 11i?
Procure to pay
Do my husband pay social security on his employee?
should my husband pay social security on his employee
What are the highest paying jobs in Massachusetts?
Most businesses that will hire part-time work will pay minimum wage. The pay may differ depending on the skills f the employee but may be about $10 per hour.
Leave without pay (LWOP) as an effect on what employee benefits?
Leave without pay (LWOP) has an effect on what employee benefits?
Should an employee pay unemployment taxes?
No, Employers pay it.
What are the highest paying part-time jobs in Massachusetts?
Most businesses that will hire part-time work will pay minimum wage. The pay may differ depending on the skills f the employee but may be about $10 per hour.
Pay for a Dairy Queen employee?
Minimum wage as an employee more as a manager....
Does a main employer have to pay earned sick leave if an employee is injured and receiving Workers Compensation on another job?
The employer is not required by law to pay out sick pay while an employee is collecting workman's comp. It depends on the employer though. In some cases an employer may pay earned sick pay to an employee collecting workman's comp. pay as a good will gesture, especailly to an employee who has had a very serious injury and has been a long term employee who has had few or no injuries.
Ten highest pay player in English premiership?
who was the highest pay player in premiership
