how to retrive only second row from table in sql server
2000?
- 3 Answers
- 6751 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / 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
| Is This Answer Correct ? | 1 Yes | 6 No |
Post New Answer View All Answers
When a non-conformance is noted during these "reviews", what happens next?
Explain what is a cause effect graph?
What are the dimensions of the risks?
What is code complete?
How do you train another QA engineer?
What is the most critical bug you found in your latest project or overall in your career ?
Where I can get ITB/ISTQB sample question paper?
How is adhoc testing different from exploratory testing?
What does the test strategy include?
Hi I m working as a sqa engineer and after 1 yr i want to switch to system analyst side kindly tell me how both fields relate each other and is this easy to switch job from qa to system analyst and what's the difference b/w both fields.
What is the difference between the test plan and test strategy
A power plant control system?
What is the difference between web, window, desktop and client server application testing?
What are the key components of a test case template
1) What r the properties, Advantages & Disadvantages of each types of action? 2)When I can use this?
