how to find the 2nd higgest salary in the column for example
take table name is employee?
And also find bottom 2nd lowest salary ?
Answer Posted / mohsin mukri
select max(salary) as Salary from tbl_Employee
where salary < (select max(salary) from tbl_employee)
sory above post ans is wrong bcoz i forgot to remove = sign
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
if there are two application 1 and 2 having a variable x in both app if client1 changes value of x in 1 app client 2 want reads the value of x from 2 app what resultant value will he get
How do you handle this COM components developed in other programming languages in .NET?
Explain the five stages in a dlx pipeline? : Dot net architecture
What is an interrupt? : .NET Architecture
The maximum report processing jobs limit configured by your system administrator has been reached.How I can Solve this problem when i using crystal report to load from my application.
Explain the difference between primary & secondary storage device? : .NET Architecture
difference between data reader and dataset
Explain the types of memory management? : .NET Architecture
difference between Response.write,server.transfer and also which one is used when ?
Explain domestic architecture artifacts? : Dot net architecture
What is .net mobile utility controls. : Microsoft dot net mobile
Whats new features in Visual Studio 2012?
What re interop services?
What is the difference between l1 and l2 cache? : Dot net architecture
Define an interrupt? : Dot net architecture