Click here to Skip to main content
15,908,673 members
Search within:


Display 1st three highest paid persons.
Please Sign up or sign in to vote.
1.00/5 (4 votes)
example
i create a taboe employee
then i insert all data
but i want to find only 3 person who getting maximum salary
Posted
Updated 15-Mar-10 7:49am
v3
Add a Solution

3 solutions

Here is everything you need: SELECT TOP[^]
 
Share this answer
 
Posted
No, sorry, don't understand a word of that.
Try giving more detail as to what your problem is.
At the moment, it just looks like you typed in a small part of your homework - ha ha ha - but you wouldn't do that, would you?
 
Share this answer
 
Posted
Adding another question to your question - only for you - What if the highest paid salary is 1000 & i have 10 employees like that? Do think over it, once you get this 3 person thing!
 
Share this answer
 
Posted
Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month
Related Questions
Display data in SQL server with three tables?
How to subtract total amount and amount paid and display the answer in another textbox
How do I display the status paid after encode the amount when the current status is not paid
How do I display the status paid after encode the amount when the current status is not paid
Hive query to find which month is highest paid salary by department
Find the highest paid employee from different department
lowest and highest salaries display
how to find highest number from three text box?
personalization
How do I print the highest of an inputted value from an array, which has the same highest value? In Python

Advertise
Privacy
Cookies
Terms of Use
Last Updated 15 Mar 2010
Layout: fixed | fluid
Copyright © CodeProject, 1999-2024
All Rights Reserved.

Web02 2.8:2024-05-30:1

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900