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. Fixed Foreign Exchange rate can be changed by

    • Options
    • A. SEBI
    • B. Ministry of Finance
    • C. RBI
    • D. All of the above
    • Discuss
    • 2. The shortcut key to quit from tally is

    • Options
    • A. CTRL + Q
    • B. CTRL + ESC
    • C. CTRL + T
    • D. CTRL + P
    • Discuss
    • 3. Where can you define the icon for your Activity ?
    • Discuss
    • 4. A website main page is called

    • Options
    • A. start page
    • B. bookmark
    • C. search page
    • D. browser page
    • Discuss
    • 5. Standard deviation measures which type of risk?

    • Options
    • A. Non diversifiable
    • B. Economic
    • C. Systematic
    • D. Total
    • Discuss
    • 6. Explain What is the difference between debenture holders and creditors?
    • Discuss
    • 7. Who is responsible for maintaining the Accounts receivable in an organization?
    • Discuss
    • 8. What are the components of DataStage?
    • Discuss
    • 9. Credit sales are recorded as

    • Options
    • A. Accounts Receivable
    • B. Accounts Payable
    • C. Both A & B
    • D. None of the above
    • Discuss
    • 10. Which of the following is not a function of a Warehouse?

    • Options
    • A. Ensuring Profit
    • B. Stabilisation in price
    • C. Risk-bearing
    • D. Storage
    • Discuss


    Comments

    There are no comments.

Enter a new Comment