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

why do not u try to get job in your core side(example :-eee)?

0 Answers   Cap Gemini,

---

What the first thing You’ll do as a SQA Tester if I hired You?

0 Answers  

---

What are the day to day activities involved in QA process ?

1 Answers  

---

what is testdata ??

3 Answers  

---

why are you leaving present company(pls give me answer other than contract employee)and give me the good reason

2 Answers   QA,

---

In case you have any doubts regarding your project, how do you approach?

0 Answers  

---

How do you differentiate the roles of Quality Assurance Manager and Project Manager?

1 Answers   IBM,

---

How would you ensure that your testing is complete and has good coverage?

0 Answers  

---

hi, they have given 2 tables to write quries in SQL SERVER 2000 based on table as follows . 1st table :author: COLUMNS AS FOLLOWS pk. AUTHOR F_NAME DOB NATIONALITY 2ND TABLE BOOKS: COLUMNS AS FOLLOWS; PK ISDN F.K AUTHOR LANGUAGE PUBLISH_DATE; 1) RETRIVE author who is indian and hindi write in a) as joins b) sub quries 2)retrive who is younger author ; 3)retrive author who wrote more than one book in different language. 4)retrive author who has wrote in different language in each year write all queries in sql for sql server

0 Answers   Covansys,

---

what is difference between software tester and quality analyst, in fact can anyone tell me what is role and responsibility for software tester,quality analyst,software quality assurance tester,test engineer,test lead,Quality Assurance manager. Quality Control Senior/junior Tester Quality Assurance Automation engineer. Quality Assurance Manual tester. Quality assurance test analyst.  

1 Answers   DS Group, TCS,

---

How does the Internal QA Audit relates with the ISO Standards level ?

0 Answers   QA,

---

please answer the difference between QA & QC with practical example

5 Answers   Protech,

---