logo

CuriousTab

CuriousTab

Discussion


Home Interview Technology See What Others Are Saying!
  • Question
  • Write SQL Query to find second highest salary of Employee.


  • Correct Answer
  • There are many ways to find second highest salary of Employee in SQL, you can either use SQL Join or Subquery to solve this problem Here is SQL query using Subquery : SELECT MAX(Salary) from Employee WHERE Salary NOT IN (select MAX(Salary) FROM Employee ); 


  • More questions

    • 1. How would you automatically transfer your visitors to a new web page?
    • Discuss
    • 2. The threshold limit upto which coins can be issued as per the Coinage Act 2011 ?

    • Options
    • A. 100
    • B. 200
    • C. 500
    • D. 1000
    • Discuss
    • 3. Cash Reserve Ratio ( CRR) and Stautory Liquidity Ratio (SLR ) are terms most closely related to which of the following industries/markets :

    • Options
    • A. Mutual Fund
    • B. Income Tax
    • C. Stock Exchange
    • D. Banking
    • Discuss
    • 4. What is the minimum period of time for which one can open an FD(Fixed Deposit) account ?

    • Options
    • A. 15 days
    • B. 6 months
    • C. 7 days
    • D. 1 year
    • Discuss
    • 5. Which Bank has been given scheduled bank status by RBI ?

    • Options
    • A. Disha
    • B. Suryoday
    • C. Janalakshmi
    • D. Ujjivan
    • Discuss
    • 6. Which class is used to indicate Black Navigation Bar ?

    • Options
    • A. .navbar-inverse
    • B. .navbar-black
    • C. .navbar-dark
    • D. .navbar-default
    • Discuss
    • 7. The journal entry to record a credit sale is

    • Options
    • A. Accounts Receivable
    • B. Accounts Payable
    • C. Both A & B
    • D. None of the above
    • Discuss
    • 8. What is CRR rate?
    • Discuss
    • 9. Which among the following are not access Specifiers in C++?

    • Options
    • A. Public
    • B. Protected
    • C. Default
    • D. Private
    • Discuss
    • 10. In which year, the first bank of India "Bank of Hindustan" was established ?

    • Options
    • A. 1677
    • B. 1770
    • C. 1796
    • D. 1831
    • Discuss


    Comments

    There are no comments.

Enter a new Comment