Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


sql satement for 2nd maximum value

Answers were Sorted based on User's Feedback



sql satement for 2nd maximum value ..

Answer / sanjay

select top 1 EmployeeID,min(Rate ) from
(select top 2 EmployeeID ,Rate from
EmployeePay
order by Rate desc)table1 group by EmployeeID ,Rate

Is This Answer Correct ?    0 Yes 0 No

sql satement for 2nd maximum value ..

Answer / manikandan

select distinct top 2 salary from employee order by salary
desc

Is This Answer Correct ?    3 Yes 4 No

sql satement for 2nd maximum value ..

Answer / chandru teamwork

Oredrs is table name orderid is collum name


select top 1 * from Orders
where orderid <=(select max(OrderID) from Orders)

Is This Answer Correct ?    0 Yes 1 No

sql satement for 2nd maximum value ..

Answer / sunil nandedkar

Select min(Salary)ThirdHighest from employees where salary
in (Select top 3 salary from employees order by salary desc)
For nth replace top 3 with top n

Is This Answer Correct ?    3 Yes 5 No

sql satement for 2nd maximum value ..

Answer / rohan patil

Select * from author where rownum=2
order by ID desc

Is This Answer Correct ?    5 Yes 20 No

Post New Answer

More VB.NET Interview Questions

What is the difference b/w Readonly Variable and Constant Variable?

7 Answers   Ksb, Sonata,


how to get dynamic control array position or its index position?

0 Answers   CMC,


What is private assembly?

0 Answers  


Explain the difference between import system.data.sqlclient and system.data.oledb?

0 Answers  


Described strong typing and weak typing?

0 Answers  


Explain the difference between system.string and system.stringbuilder classes?

0 Answers  


What is a preprocessor directive in vb.net?

0 Answers  


Name the tool which can convert visual basic old version to .net compatibility version?

0 Answers  


Write a program that would find the nth term of a geometric progression, given the value of first term and common ratio. Any inbuilt function that the language provides for calculating exponent should not be used.

0 Answers  


hello dear friends my problem is that i want to save images that is pictures in SQL server using vb.net can any body help me to do so please

1 Answers  


Can we use a crystal report into a another crystal report

7 Answers  


What is redim keyword and its use?

0 Answers  


Categories