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 |
Types of reviews and explain them????
What is meant by formal and informal testing? Under which category it comes?
What type of testing do we perform in requirement phase?
what is the difference between test case and testscenario,plz answer for this
what are different reports prepared by a tester and their templates.
can we give special characters in password
plz dont give any def. wat actions do u perform on website while doing monkey testing? or how can u do monkey testing?
If date field is a text field write test cases to validate it?
what is lifecycle of a buG??? give an example of high severioty and low priority bug???
what is effect variance ,Budget variance , Schedule Variance , Defect Density ?
What is the difference between Build and Version?
define with example high severity and low priority ? 2.low severity and high priority? 3.both are high? 4.both are low ?