Answer Posted / ashish

select salary from
(select dense_rank() over(order by salary desc) as highest, salary from employee)as y
where highest=2

: replace 2 with n.... it will give nth highest salary
: rank() will work correctly only if all the salaries in employee table are distinct.
: dense_rank() will work correctly, does'nt matter salaries are distinct or NOT.

We have a testing assignment that is time-driven. Do you think automated tests are the best solution?

2115

---

Tell us what you know about table-driven testing?

987

---

What are the most popular tools for automation testing?

1013

---

What is data - driven automation?

2682

---

Can any one give me the script for drag and drop or setselection functions ?like in a not pad i want to select 5 lines

2001

---

What is a ‘test plan’? What is a ‘test case’?

1058

---

Explain me what is a framework and what are the frameworks available in rc?

979

---

What is vendor tool and give examples?

1090

---

Which protocol cam be used to makw jdbc connection woth loadrunner

1017

---

How can we make one test method dependent on other using testng?

999

---

How can you switch back from a frame?

1021

---

if i want to use different values in datatable with each iteration of for loop what would i do ??/

2098

---

What is test automation or automation testing?

983

---

How can you create html test report from your test script?

1007

---

HOW DO YOU PERFORM SECURITY TESTING TO VERIFY FIREWALLS,PASWORD ENCRYPTOPNS ETC?

2394

---