Since I am looking for a job change and this is the question I’m being asked in all of my interviews, I am sharing this with everyone hoping this will help you guys.

The most common type of question is find out the 5th highest value, find out the 2nd highest value, and so on.

The solution for this question goes like this, I am going to fetch 5th highest salary for an employee.

Select top 1 FirstName, Salary From Employees Where Salary Not In (Select Distinct Top 4 Salary From Employees order by Salary desc) order by Salary desc

Enjoy and have fun

If you are involved in something that goes wrong, never blame other. Blame no one but yourself.

If you have touched something, accept total responsibility for that piece of work. If you accept responsibility, you are in a position to do something about it.

Here are some common excuses for failures:

- It was a terrible brief.

- I need a better partner.

- There wasn’t enough money to do it properly.

- The director didn’t listen to me.

- I was too busy on other projects.

- I wasn’t given enough time.

- The client took out the best ideas.

Most of these grievances are everyday on every job. That won’t change.

The point is that, whatever other people are failings might be, you are the one to shoulder the responsibility.