page
Home
About Us
Contact Us
Friday, April 11, 2008
find Nth highest salary of employee by procedure
[sourcecode language="sql"]
Create proc GetNthmaxsalary
(
@high int
)
as
set nocount on
SELECT TOP 1 emp1.salary FROM ( SELECT DISTINCT TOP @high salary FROM emp ORDER BY salary DESC) as emp1 ORDER BY emp1.salary
go
}
[/sourcecode]
Facebook
Twitter
Google+
Pinterest
StumbleUpon
Dig
LinkedIn
No comments :
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments ( Atom )
AJAX, asp, Asp.net, asp.net and sql server security, Asp.net IntemIndex, C#, Css, DataBinder.Eval, DataKeyNames, Datalist, Datapager, DataSet, DataTable, DropDownList, FindControl, gridview, JavaScript, jquery, Listview, Paging, Regex, RegularExpression, Repeater, Server side validation, Sql Server, timer, timercallback, Validation, XML, xmlnode, XPath
No comments :
Post a Comment