Sunday, 24 November 2013

How to find 6th highest salary



  1. SELECT TOP 1 salary
    FROM (SELECT DISTINCT TOP 6 salary
    FROM employee
    ORDER BY salary DESC) a
    ORDER BY salary

Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Popular Posts

  • ASP.NET MULTIPLE CHOICE QUESTIONS
    ASP.NET QUESTIONS 1) On which of the operating system below ASP.NET can run?             a)   Windows XP Professional      ...
  • Index Optimization tips
    T-SQL Queries 2 tables Employee Phone empid empname salary mgrid empid phnumber Select all employees...
  • DOT NET MCQ QUESTIONS PART5
    76) Select the control which does not have any visible interface                a) Datalist                b) DropdownList          ...
  • DOTNET MNC TECHNICAL INTERVIEW PART 1
    1. What is a Web service ? How it is different from remoting? 2. Diiferent life cycle events phases in asp.net web form. 3. OOPS conc...
  • ASP DOTNET MCQ QUESTIONS PART3
    56) Which of the following is true ?                a) IsPostBack is a method of System.UI.Web.Page class                 b) IsPostBa...
  • Interview Questions .NET Windows Forms
    Interview Questions .NET Windows Forms 1)   Write a simple Windows Forms MessageBox statement? 2)   Can you write a class witho...
  • ASP DOTNET MCQ QUESTIONS PART 9
    126) Which of the following denote ways to manage state in an ASP.Net Application?               a) Session objects               b)...
  • Asp.net Page Life cycle
    Asp.net Page Life cycle This is a transcript of a  programming manual, to refresh my memory, and it’s always good to RTFM. As a contro...
  • DOTNET MNC TECHNICAL INTERVIEW QUESTIONS PART 2
    1. What is caching.? 2. Types of cahing? 3. What is cache Block? 4. What are indexers? 5. What is difference between Namespace and assembl...
  • ASP DOTNET MULTIPLE CHOICE QUESTIONS PART 1
    21) To set page title dynamically in ASP.NET which of the following is used ?                a) None of the above                b) ...