To find Second highest salary
select top 2 * from Trainee.dbo.Depart where Salary in(select top 1 Salary from Trainee.dbo.Depart)order by Salary DESC
Subscribe to:
Post Comments (Atom)
-
ViewBag, ViewData, TempData and View State in MVC ASP.NET MVC offers us three options ViewData, ViewBag and TempData for passing data from...
-
// Export Datatable to Excel in C# Windows application using System; using System.Data; using System.IO; using System.Windows.Forms; ...
No comments:
Post a Comment
Comments Welcome