Please give examples of SQL interview questions for junior position?

0
0

Write a SQL query to find the 10th highest employee salary from an Employee table. Explain your answer.

(Note: You may assume that there are at least 10 records in the Employee table.)

  • You must to post comments
0
0

Given a table SALARIES, such as the one below, that has m = male and f = femalevalues. Swap all f and m values (i.e., change all f values to m and vice versa) with a single update query and no intermediate temp table.

Id  Name  Sex  Salary
1   A     m    2500
2   B     f    1500
3   C     m    5500
4   D     f    500
  • You must to post comments
0
0

 I have been asked to explain what Primary key and Index are and to write a simple query. You also might be ask to explain the different types of JOIN and Having or Group by. Basically, you shouldn't be stressed about the SQL questions if you know the basics.

  • You must to post comments
Showing 3 results
Your Answer
Post as a guest by filling out the fields below or if you already have an account.
Name*
E-mail*
Website