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

Display a roll having miminum marks in two subjects?

Answer Posted / ivee

Suppose we are having a table called abc which has field
name as marks, subject and roll
now roll2 and roll3 has the same minimum marks as 40
so the query will be

select roll from abc where marks=(select min(marks) from
abc)

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What does executeupdate return?

1033


What are the 3 types of schema?

1174


Tell me what is the significance of null value and why should we avoid permitting null values?

1038


What is transaction server distributed transaction?

1126


how to create “alternate row colour”?

152


between cast and convert which function would you prefer and why?

1010


hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.

2111


What do you do in data exploration

1050


How to move database physical files in ms sql server?

1094


What is primary key and example?

994


What should be the fill factor for indexes created on tables? : sql server database administration

1177


Why I am getting this error when dropping a database in ms sql server?

1117


What are partitioned views?

1051


Can I delete event logs?

977


What are the dmvs? : sql server database administration

1118