how to retrive only second row from table?
Answers were Sorted based on User's Feedback
Answer / magesh n
My answer will work in Oracle SQL but not sure in MS-SQL.
Query is:
select * from tablename where rownum=2;
rownum is the pseudo-column in oracle sql.
| Is This Answer Correct ? | 2 Yes | 2 No |
Answer / karthik rahul
HI guys
THis Is Karthik Rahul
I think to select the data from second row of a particular
table, we must know at least one coloumn value on that
particular table......
if it is wrong pl. send da correct one ro my mail
karthik_lboy@yahoo.co.in
9985315383 Hyderabad
| Is This Answer Correct ? | 0 Yes | 1 No |
There is an opening in our organization Sierra Atlantic, Hyderabad. All Manual test engineers with 2-3 years or experience can forward your resumes to mah_cs82@yahoo.com before May 01, 2008. (Only manual testers)
what is prototype testing?
what are the contents we have to cover in manual testing to get the job
When first time we are testing the screen then we have to write that this screen should contains so & so columns [ suppose there r 10 columns on that screen]in the expected result
Difference between gui & Functional testing
8. What are the last three Web accessibility topics or questions you researched on the Internet?
What is actually a rule based testing
What is deferred?
Give me two examples of HLD and LLD...
Smoke testing is also called sanity testing? Why?
How to test Requirements?
In a system designed to work out the tax to be paid: An employee has £4000 of salary tax free. The next £1500 is taxed at 10% The next £28000 is taxed at 22% Any further amount is taxed at 40% To the nearest whole pound, which of these is a valid Boundary Value Analysis test case? The options provided are a)£1500 b)£32001 c)£33501 d)£28000