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
- 20155 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / srinu
1) using external filter we use command is sed we get
2)select * from (select rownum rno,emp.* from emp)
where rno in(5,6,7)
or
select * from (select rownum rno,emp.* from emp)
where rno between 5 and 7
or
select * from emp where rownum<8
minus
select * from emp where rownum<5
in first two are very efiiciency compare to third one
because in third iam using set operator
3)select * from emp where rowid=(select max(rowid) from emp);
| Is This Answer Correct ? | 11 Yes | 0 No |
Post New Answer View All Answers
Which warehouse using in your datawarehouse
Triggers,VIEW,Procedures
What is "fatal error/rdbms code 3996" error?
What are the functionalities of link partitioner?
How do you import and export the datastage jobs?
What are transforms and what is the differenece between routines and transforms?
What are the steps required to kill the job in Datastage?
What are sequencers?
Define meta stage?
explain about citrix scheduling tool in datastage
How you can fix the truncated data error in datastage?
In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name
How to reverse the string using SQL?
Different ways a project can be moved to production ?...example ….export-import and Version control.
Have you used Unstructured data?
