Get Top 3rd salary using MS SQL server

You can get any number of Top salary by using below query

WITH CTE AS
(
    SELECT EmpID, EmpName, EmpSalary,
           RN = ROW_NUMBER() OVER (ORDER BY EmpSalary DESC)
    FROM dbo.Salary
)
SELECT EmpID, EmpName, EmpSalary
FROM CTE
WHERE RN = @NthRow
If somebody ask for Top 3rd salary, then i'll replace 3 to @NthRow then i'll execute query. and then i'll get top 3rd salary.  

Comments

Post a Comment

Popular posts from this blog

how to fetch all HTML Table Records and modify all records accordingly using jquery and Javascript

In my example, I have fetch HTML Table Records and Convert to Class List Object for C# Result: Click Here < script src = "https://ajax.googleapis.com/ajax/libs/jquery/3.6.3/jquery.min.js" ></ script > < script >   $ ( document ). ready ( function () {     // Get the table element     const table = document . getElementsByTagName ( "table" )[ 0 ];     // Get all the table rows     const rows = table . rows ;     // Create an empty array to store the table data     const data = [];     // Loop through each row and get the cell data     for ( let i = 0 ; i < rows . length ; i ++) {       const cells = rows [ i ]. cells ;       const rowData = {};       //new Columns { CharacterName = "", Char = "", Code = "", Decimal = "", Binary = "", Hex = "" },       var stringCon = "new Columns {" ;       /...
Read more

Optimize Process Speed using C#

To optimized code speed you can use System.Diagnostics  Namespace. ============================= using System; using System.Diagnostics; using System.Threading; namespace DiagnoseProcessSpeed {     internal class Program     {         static void Main()         {             Stopwatch sw = Stopwatch.StartNew(); // Start Stopwatch             for (int i = 1; i < 11; i++)             {                 System.Console.WriteLine("Loop : " + i);                 Thread.Sleep(1000);// interval for 1 seconds.             }             sw.Stop(); // End Stopwatch             //sw.Elapsed Contain Process Taking Time in Seconds             System....
Read more

how to Replace null value with 0 Using C#

how to Replace null value with 0 Using C# //here we suppose that objDataTable have data collection as table now access this //datatable object. decimal  j = 0;  j = objDataTable.Rows[0]["Qty"] ==  DBNull .Value ? 0 :  Convert .ToDecimal(objDataTable.Rows[0]["Qty"]); NOTE :- //if   DBNull.value is null  then   "0 " else  "your code here")  // ? = then // : = else Thank You [Sumit Singh Shekhawat]
Read more