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 |
Which methodology u follow in testcase?
Can you explain requirement traceability and its importance?
What is the mean by Test Management,Test Design,Test Execution,Test Plan,Test Specification?
There is a front end application to enter name and marital status. you are provided with a fesh database. On entering 5 set of data at a time an error occured, but on entering rest of the records you were not able to reproduce it. What could have been the reason for the error.
When requirement / SRS document comes to a tester then Do we prepare the test cases +ve & -ve at a time?
how do you ensure by testing that the transactional refuilement or an application are met
Diff between static and dynamic review?
what is the use of l10n testing?
Difference between Severity & Priority?
How do you go about testing a web application?
Notepad(Editor),we test is which type of testing? a)Functionality Testing,b)Compatability Testing,c) All,d) None
What is reliable testing? Give me an example