how to retrive only second row from table in sql server
2000?
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
Define test strategy.
What is cross browser testing?
What are the types of documents in sqa?
If there are more number of production defects, how will you tackle the team as a lead
Mention the different types of software testing?
how cani do requirement testing using some testcase
How do you decide you have tested enough?
hi, they have given 2 tables to write quries in SQL SERVER 2000 based on table as follows . 1st table :author: COLUMNS AS FOLLOWS pk. AUTHOR F_NAME DOB NATIONALITY 2ND TABLE BOOKS: COLUMNS AS FOLLOWS; PK ISDN F.K AUTHOR LANGUAGE PUBLISH_DATE; 1) RETRIVE author who is indian and hindi write in a) as joins b) sub quries 2)retrive who is younger author ; 3)retrive author who wrote more than one book in different language. 4)retrive author who has wrote in different language in each year write all queries in sql for sql server
Hello Can anyone please share the interview details for QA positions in Tribal Fusion, Noida. Much Thanks
What has not worked well in your previous QA experience and what would you change?
Will automated testing tools make testing easier?
What are the different artifacts you refer when you write the test cases?
In case you have any doubts regarding your project, how do you approach?
How to test and to get the difference between two images which is in the same window?
What is the quality audit?