SQL Server Performance

Search Results

Search Again
  1. recherche

    nth highest salary without using TOP and sub-query from the following table

    Post by: recherche, May 3, 2012 in forum: ALL SQL SERVER QUESTIONS
    Thanks for the input :).
  2. recherche

    nth highest salary without using TOP and sub-query from the following table

    Post by: recherche, Apr 28, 2012 in forum: ALL SQL SERVER QUESTIONS
    I guess the answer is ;WITH CTE AS ( SELECT Salary, rnk=DENSE_RANK() OVER (ORDER BY Salary DESC) FROM Employee ) SELECT DISTINCT Salary FROM CTE...
  3. recherche

    nth highest salary without using TOP and sub-query from the following table

    Post by: recherche, Apr 28, 2012 in forum: ALL SQL SERVER QUESTIONS
    Thought this forum was about SQL Server Q&A. Don't know why the replies are so "pedagogical". Anywise, I am just a learner who wanted to hear it...
  4. recherche

    nth highest salary without using TOP and sub-query from the following table

    Post by: recherche, Apr 27, 2012 in forum: ALL SQL SERVER QUESTIONS
    Excuse me, school teacher. The question is for SQL Server experts.
  5. recherche

    nth highest salary without using TOP and sub-query from the following table

    Thread by: recherche, Apr 27, 2012, 7 replies, in forum: ALL SQL SERVER QUESTIONS
    Hi SQL Server Experts, I want to get the nth highest salary without using TOP and sub-query from the following table. USE [master]; GO IF...
Showing results 1 to 5 of 5
Search Again