Interested to Buy Any Domain ? << Click Here >> for more details...
1) In a dataset how to delete a single row?
2) i have 50 rows , i want to display 5-7 records only?
How to write the sql query?
3)i have 40 rows,i want to display last row? write sql query?
- 7 Answers
- 19677 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / reddy obul
__for 2nd question answer is:
select * from table where rowid<8 minus select * from table
where rowid<5
__for 3rd quesion answer is:
select * from emp where rowid in(select max(rowid) from emp)
| Is This Answer Correct ? | 9 Yes | 9 No |
Post New Answer View All Answers
What are the important features of datastage?
How to reverse the string using unix?
Have you used Unstructured data?
What are the job parameters?
How many types of views are there in a datastage director?
What could be a data source system?
project Steps,hits, Project level HArd things,Solved methods?
How do you import and export the datastage jobs?
What is the difference between hashfile and sequential file?
What are some prerequisites for datastage?
Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2
Can you explain kafka connector?
Difference between data warehousing and olap?
whom do you report?
What is the purpose of pivot stage and types of containers in datastage
