how to retrive only second row from table in sql server
2000?
- 3 Answers
- 7306 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / 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
| Is This Answer Correct ? | 0 Yes | 4 No |
Post New Answer View All Answers
How to log defect in HP ALM
Scenario :- when we test payment module in the eCommerce site, then how do we verify or actually check transaction failed and the amount will be returned in next few days? i am using pay pal / credit card.
What are the benefits of automated testing?
hello.. i have learnt testing manual and automation tools and im working as test engineer in a software company still i do need more testing skill so where can i get more knowledge about testing . please advice me
what is the difference between testing techniques and principles of testing?Kindly explain both of them with an example.
Mention some of the types of software testing?
What is the quality audit?
Explain cmmi.
Enlist some of the key challenges that are faced while performing software testing.
What is mr and er?
What is the difference between preventative and reactive approaches in testing?
What is process area in cmmi?
What is basic block?
hi , This is krish from chennai . i like to do istqb certification for foundation level . if any one have material for that kidely help me. just send me the material to krishmca29@rediffmail.com. thanks is advance for sending .
We have one home page for a web application.It has so many components which are being tested by different teams. If one component testing get delayed but all other components testing is done, can we sign off testing for that home page? If no, what should be done?
