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 |
You don’t have much time or only one day time, you have to execute 100 test cases, how you will execute
What are the steps need to be taken while testing stored procedures?
While testing stored procedures what are the steps does a tester takes?
What is difference between local and global temporary table?
How to test procedures and triggers of a database?
What are dcl commands? What are the two types of commands used by dcl?
Does qtp support sql queries?
What do you mean by index and explain different types of indexes?
How do you test whether the database is updated as and when an information are added in the front end?give me an example?
How to write test cases from requirements, do the requirements signify the exact functionality of aut?
What is the process of database testing?
What are joins?