Suppose a student column has two columns, name and marks. How to get name and marks of top three students.
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 |
What rdbms stands for and what are the important rdmbs that sql use?
Explain the qtp testing process?
How to use sql queries in qtp?
What are dcl commands? What are the two types of commands used by dcl?
What is the meaning of record in a database?
Explain database testing?
Suppose a student column has two columns, name and marks. How to get name and marks of top three students.
In database testing, how to do the data load testing?
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?
What do you mean by dcl commands and explain the types of commands used by dcl?
What are the steps to test data loading in database testing?
Which sql statements can be used in database testing?