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 |
What is the difference between QA and QC?
what id test effort Estimation in testing ?
Do I have to write separate test cases for entering special characters, blank space, numbers in First name field ? Or should I create single test case for it? If yes then how?
what are the various levels of testing?
hello there, can anyone tell me what type of question does lg soft company ask in written test especially for a quant part? Thanku
Hi harish n Satish...thanx for the response... Already told Functionality testing and user interface type testing to interviewer but he was expecting something else. And also explained test cases....Is it data driven testing for user id and password combinations? If i am not wrong....?
What type of Bugs will occur in Banking Project and pls send the Scenario,Testcases for the same?
What is difference between Development envionment and Test enviornment.
can anybody tell me what is release process of company? release note?
What are the references for Perl scripting language?Is there a software tester should have this knowledge .?
what is the output of this query selet * from employee where 1=2
What is the different cost elements involved in implementing process in an organization?