Three maximum salaries from SQL table

Hello, I want to Open a pop-up like in following link for the first time site open on any PC: http://www.nomorerack.com/ I have created Login page now i want to convert taht into a pop wondow like the given link,please help me how i can do this? (IN ASP.NET) Looking forward for kind response. Thanks.

sarin s14y ago

SELECT TOP(3) [nSalary]
FROM tblEmployeeInfo
ORDER BY [nSalary] DESC

Vulpes14y ago

You didn't say which database you are using but, if you're using one which doesn't support the TOP keyword (such as MySql or Oracle), you can use instead:

SELECT Salary

FROM Employee

ORDER BY Salary DESC

LIMIT 3

Rajaprabhu Raja14y ago

Hi,

you can use this query...

select top 3 salary from tbl_Employee order by salary desc