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 do you understand by physical_only option in dbcc checkdb?

979


What do you mean by table and field in sql?

1015


Explain use of expression builder.

1017


How do you debug a procedure in sql server?

945


What is user-defined multi-statement table-valued function?

1061


Why use cursor in sql server?

1077


Can we delete data from a view?

924


In how many ways you can invoke ssrs reports?

139


What are the requirements for sql server 2016?

882


What you can do to delete a table without the delete trigger firing?

973


What are the Advantages of using CTE in sql server?

1119


How does the report manager work in SSRS?

150


Explain what is analysis service repository?

1000


What is report snapshot in ssrs?

268


what is difference between view and Dip.

2409