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...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

I have student marks in a student table. I need second
highest mark .Then what will the query for this?

Question Posted / sanah

Answer Posted / sanah

select top 1 marks from marks where marks
<(select max(marks) from marks) order by 1 desc

Is This Answer Correct ?    3 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Define compound operators?

965

We are updating a field in sql and alter the row also.after giving the commit command the system is crashed.what will happen to the commands given,whether it will update and alter the table or not?

1443

What are extended events in sql server?

1007

In which tcp/ip port does sql server run? Can it be changed?

1038

What is page in sql server?

995

What xml support does the sql server extend?

1057

What are the differences in Clustering in SQL Server 2005 and 2008 or 2008 R2?

1101

What are the lambda triggers?

957

What is default port number for sql server 2000?

1105

What is a full text index?

965

How to configure odbc dsn with different port numbers?

1152

how to determine the service pack currently installed on sql server? : Sql server database administration

1026

What is a heap?

1083

What is cross join in sql server joins?

1201

Explain transaction server explicit transaction?

972