Answer / swagata mukherjee

Select < fields names > from <table name > Limit 1,1

Answer / nagapawan

eg:

select top2 * from tablename
this table retrive only second row only

from 2nd row if u want only number and name

then like this we have to write
eg:
select top2 empno,ename from emp

Answer / prakash t

Here you go,

for example , consider one EPmloyee table , to get a 2nd
row :

General syntax :

Select < fields names > from <table name > where rownum
= <row ID>

Ex : select Ename , Eid , Designation from Employee where
rownum=2

Kindly tell me some good websites from where I can study about sqa and testing(advance and new material)

0 Answers  

---

Give me example of automate the regression test suite ........Thanks...

0 Answers   Apotex,

---

how will you define your bug status flow in softsmith qamonitor?

1 Answers  

---

What are the technical risks involved in Software testing project?

2 Answers   CTS,

---

What are the various ways of writing test cases?

1 Answers   Dataquest,

---

What is the strategy for automation test plan?

0 Answers  

---

what is the difference between RDBMS and DBMS

5 Answers   Oracle, Xansa,

---

Can you suggest a test system with interactive desktops, live dashboards, and instant communication features?

2 Answers  

---

What is error guessing?

1 Answers  

---

Field level test cases are developed using AF TOD to validate individual fields on a screen using a black box testing methodology. IN THIS CONTEXT WHAT IS "AF TOD"

0 Answers  

---

What is extreme programming and what is it got to do with testing?

0 Answers  

---

What mental attitude do You have, if You are really qualified to this Tester Job?

2 Answers  

---