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
Explain different pipelining hazards and how are they eliminated? : Dot net architecture
How does an appdomain get created?
What is one way operation?
Explain about appdomains?
What is .net mobile input validation. Explain with an example? : Microsoft dot net mobile
Session State and can i store desirialized object in state server, if yes how and if not why.
What is the purpose of hard disk? : Dot net architecture
How do I stop a thread?
How do I know when my thread pool work item has completed?
Can you explain update progress control?
How to implement the display in the class printdoc (how to resolve the naming conflict) a: no naming conflicts
How can we integrate atlas with web services?
Explain the number or character entered through keyboard gets converted to equivalent ascii code & it get stored on ram in the binary form. What is the exact procedure on hardware that converts the ascii value to binary? : .NET Architecture
What is Object Caching in Visual Studio 2010?
Explain the use of virtual, sealed, override, and abstract.