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


Suppose a student column has two columns, name and marks. How to get name and marks of top three students.



Suppose a student column has two columns, name and marks. How to get name and marks of top three stu..

Answer / krishna

SELECT Name, Marks FROM Student s1 where 3 <= (SELECT COUNT(*) FROM Students s2 WHERE s1.marks = s2.marks)

Is This Answer Correct ?    4 Yes 0 No

Post New Answer

More Database Testing Interview Questions

What rdbms stands for and what are the important rdmbs that sql use?

0 Answers  


Explain the qtp testing process?

0 Answers  


How to use sql queries in qtp?

0 Answers  


What are dcl commands? What are the two types of commands used by dcl?

0 Answers  


What is the meaning of record in a database?

0 Answers  


Explain database testing?

0 Answers  


Suppose a student column has two columns, name and marks. How to get name and marks of top three students.

1 Answers  


In database testing, how to do the data load testing?

0 Answers  


How to test a dts package created for data insert update and delete? What should be considered in the above case while testing it? What conditions are to be checked if the data is inserted, updated or deleted using a text files?

0 Answers  


What do you mean by dcl commands and explain the types of commands used by dcl?

0 Answers  


What are the steps to test data loading in database testing?

0 Answers  


Which sql statements can be used in database testing?

0 Answers  


Categories