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 |
How to test database procedures and triggers?
What is a trigger? How do you verify if a trigger is fired or not?
How to test database manually?
What are the different stages involved in database testing?
How to verify the trigger is fired or not and can you invoke trigger on demand?
What is cmmi and describe different levels of cmm?
How we can avoid duplicating records in a query?
How to check a trigger is fired or not, while doing database testing?
How do you test whether the database is updated as and when an information are added in the front end?give me an example?
Suppose a student column has two columns, name and marks. How to get name and marks of top three students.
To manage and manipulate the test table what are the sql statements that you have used in database testing?
What is load testing and give some examples of it?