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
- 19595 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 is the importance of the exception activity in datastage?
What are the different type of jobs in datastage?
What are the different types of lookups in datastage?
What are the steps required to kill the job in Datastage?
What is the difference between datastage and datastage tx?
How to read the length of word in unix?
What is a merge?
How to read multiple files using a single datastage job if files have the same metadata?
sed,awk,head
Differentiate between datastage and datastage tx?
how many rows sorted in sort stage by default in server jobs
What is usage analysis in datastage?
To see hidden files in LINIX?
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
How many types of stage?
