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?
What are joins and mention different types of joins?
Explain how to use sql queries in qtp ?
Without involving database checkpoints, how you can test a sql query in qtp?
What we normally check for the database testing?
How to test database in manually?
What is data driven test?
In database testing, what all things are required for writing good test cases?
What is difference between local and global temporary table?
What steps does a tester take in testing stored procedures?
What is the process of database testing?
In the database testing process, what do we usually check?