Tuesday, March 23, 2010

Query to get second highest value from a table

This query is to get second highest salary from a table

select top1 salary from(select top2 salary from employee order by salary desc)
employee order by salary asc

Action Method in Mvc

In this section, you will learn about the action method of controller class. All the public methods of a Controller class are called Act...