Providence Global Center Interview Questions: SQL Question Query to retrieve the employee name with second

Asked inProvidence Global Center,Software Engineer

SQL Question

Query to retrieve the employee name with second maximum salary from given table (there are 3 tables Employee(ID,name), Salary(Esalary,post) , Works For(ID,Salary)).

Be the first one to answer

Add answer anonymously...

Top Providence Global Center Software Engineer interview questions & answers

Q1. Two SumYou are given an array of integers 'ARR' of length 'N' and an integer Target. Your task is to return all pairs of...read more

View answer (1)

Q2. SQL QuestionsWrite a query to find names of the customers who have purchased less than or equal to one product. Order th...read more

Add answer

Q3. SudokuYou are given a 9x9 sudoku. Your task is to solve sudoku and return the solution. A sudoku is a puzzle in which pl...read more

View answer (1)

Providence Global Center

Discover recent interview experiences

View all

Interview Tips & Stories

Ace your next interview with expert advice and inspiring stories

Explore community

Popular interview questions of Software Engineer

Q1. Bridge and torch problem : Four people come to a river in the nig...read more

asked in

Qualcomm

View answers (171)

Q2. In a dark room,there is a box of 18 white and 5 black gloves. You...read more

asked in

Capgemini

View answers (521)

Q3. Find DuplicateYou have been given an integer array/list(ARR) of s...read more

asked in

Providence Global Center Interview Questions

Providence Global Center Software Engineer Interview Questions

Stay ahead in your career. Get AmbitionBox app

Helping over 1 Crore job seekers every month in choosing their right fit company

65 L+

Reviews

4 L+

Interviews

4 Cr+

Salaries

1 Cr+

Users/Month

65 Lakh+

Reviews

4 Lakh+

Interviews

4 Crore+

Salaries

1 Crore+

Users/Month

Contribute

Contribute to help millions

Reviews

Get AmbitionBox app