[askdba] Re: solution needed
- From: "Subodh Deshpande" <subodh_deshpande@xxxxxxxxx>
- To: askdba@xxxxxxxxxxxxx
- Date: Fri, 24 Sep 2004 06:50:18 -0500
hi sanjay,
i feel this can be done with lag,lead function with windowing options..
do not have the exact syntex, but pretty sure that i have read about similar to
this in tom kyte experts one on one book..
----- Original Message -----
From: <sanjay.khangarot@xxxxxxxxx>
Date: Fri, 24 Sep 2004 10:56:26 +0530
To: <askdba@xxxxxxxxxxxxx>
Subject: [askdba] Re: solution needed
>
> suppose u want 2 pick evry 2nd row then
> select * from emp where (rowid,0) in (select rowid,mod(rownum,2) from emp)
>
> -----Original Message-----
> From: askdba-bounce@xxxxxxxxxxxxx [mailto:askdba-bounce@xxxxxxxxxxxxx]On
> Behalf Of Soumya K. Mishra
> Sent: Friday, September 24, 2004 10:43 AM
> To: askdba@xxxxxxxxxxxxx
> Subject: [askdba] solution needed
>
>
> Q1) Below given is a simple table with Customer_id and Book_Name as 2
> fields. Analyzing the book name we can see that every third book is a
> book on database technology. I want to design a query to retrieve the
> 1st record, the 4th ,the 7th and the 10th.
> And generalize it to n no of rows i.e retrieve every nth record. Please
> suggest solution.
>
> =0D
>
> =0D
>
> Customer_id=0D
>
> Book_Name
>
> 001
>
> Mastering oracle sql
>
> 002
>
> Microbiology for beginners
>
> 003
>
> Algebra by Hall n Night
>
> 004
>
> Inside of SQL Server
>
> 005
>
> Economics by M.L Seth
>
> 006
>
> Modern India History
>
> 007
>
> DB2 for programmers
>
> 008
>
> Universe in a Nutshell Stephen Hawking
>
> 009
>
> Mutation by Robin Cook
>
> 010
>
> Oracle 9i database administration fundamentals 1
>
> =0D
>
> Q2) I was asked in an interview a proposed solution for the following
> problem:
>
> =0D
>
> Interviewer: The order management department manager faces the following
> problem in the subsequent module of SAP ERP package-
>
> Each time he makes an update of the latest order, it takes quite a lot
> time to be reflected in the different module of that ERP solution. What
> is that as a DBA you can check for it?
>
> =0D
>
> I need to know in which field the DBA should put his concentration:
>
> =0D
>
> Application programming: should go for the tuning of the queries, procs,
> indexes, packages that the ERP application uses.
>
> =0D
>
> Core DBA: should he go for managing the data dictionary, the buffer
> cache , the table spaces for the user etc.
>
> =0D
>
> System Administration: should he suggest for configuring the controller
> set up?
>
> Ex: change the RAID set up from 15 to 01...
>
> =0D
>
> Thanks=0D
>
> =0D
>
> Soumya Mishra.
>
> =0D
>
>
>
>
>
>
> Confidentiality Notice=0D
>
> The information contained in this electronic message and any attachments to=
> this message are intended
> for the exclusive use of the addressee(s) and may contain confidential or=
> privileged information. If
> you are not the intended recipient, please notify the sender at Wipro or=
> Mailadmin@xxxxxxxxx immediately
> and destroy all copies of this message and any attachments.
>
Good Luck..Subodh Deshpande
===============================================
Experience Is Knowledge
Wisdom Is Philosophy
==============================================
--
_______________________________________________
Find what you are looking for with the Lycos Yellow Pages
http://r.lycos.com/r/yp_emailfooter/http://yellowpages.lycos.com/default.asp?SRC=lycos10
Other related posts: