Infosys Full Stack .NET Mid

Write the idea for 3rd highest salary in SQL.

Use RANK() or DENSE_RANK() over salary DESC and filter rank = 3. Or OFFSET/FETCH after DISTINCT salaries. Interviewers care you know duplicates: RANK skips numbers; DENSE_RANK does not.

Infosys rounds often probe: Enterprise .NET.

Themes commonly reported in public MNC interview experiences (AmbitionBox / LinkedIn / Glassdoor-style). Practice aloud; keep answers this short in the real round.

More Infosys Full Stack .NET questions

Explain Dependency Injection lifetimes in ASP.NET Core.
What is the difference between authentication and authorization?
How do you prevent SQL injection in .NET?
Explain JWT and where you store it on the client.
What is the N+1 query problem?
Abstract class vs interface in C#?

All Full Stack .NET questions

Toolliyo Assistant

Ask about tutorials, ebooks, training, pricing, mentor services, and support. I use public site content only—not admin or internal tools.

care@toolliyo.com