Maersk - SQL Programming

 SQL Programming

1.1.   Write an SQL query to show only odd rows from Employee table.

Output:

Id

1

3

5

7

9

 

2.2. Write an SQL to find 2nd highest salary of an employee from above Employee table?

3.3. Write an SQL query to fetch the list of employees with the same salary.