logo

CuriousTab

CuriousTab

Discussion


Home Interview Technology Comments

  • 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 ); 


  • Technology problems


    Search Results


    • 1. Write a SQL Query to find year from date.
    • Discuss
    • 2. How does fault tolerance work in mapreduce?
    • Discuss
    • 3. What are the security laws which take care of the data in the cloud?
    • Discuss
    • 4. What is ARC ?
    • Discuss
    • 5. What is Automatic Reference Counting (ARC) ?
    • Discuss
    • 6. A UNION query is which of the following?

    • Options
    • A. Combines the output from multiple queries and does not include the same number of columns.
    • B. Combines the output from multiple queries and must include the same number of columns.
    • C. Combines the output from no more than two queries and does not include the same number of columns.
    • D. Combines the output from no more than two queries and must include the same number of columns.
    • Discuss
    • 7. What is ALV programming in ABAP? When is this grid used in ABAP?
    • Discuss
    • 8. What is the differences between ABAP and OOABAP. In which situation we use OOABAP?
    • Discuss
    • 9. What is CTS and what do you know about it?
    • Discuss
    • 10. Which of the following is not considered a JavaScript operator?

    • Options
    • A. new
    • B. this
    • C. delete
    • D. typeof
    • Discuss


    Comments

    There are no comments.

Enter a new Comment