I'm newbie in Oracle and I am programming some stuff things but I need to do something that it's beyond me.  First of all, I have to use Oracle 8i  We start with a table with data similar to:  Column1  Column2       A        7       A        9       A       13       B        5       B        6       C        1       C        4       C        9       C       40   I need to take FIRST 2 values from this table for EACH letter (column1)  Value1 = n1 Value2 = n2  For example, for A values are 7 and 9 but for B are 5 and 6  Sorry, I can't draw a table (  And I don't know how many letter could have this table ofc, so I suppose the best way it's maybe a LOOP for all table, taking just first and second row (table is arranged and ALWAYS need first and second values for each letter) but I'm not sure how can I do...  Maybe a query filter by column1 and a rownum &lt;3 ? I'm not sure if this query always take just first 2 values or take 2 aleatory values...
How would I be able to get N results for several groups in an oracle query.  For example, given the following table:  |--------+------------+------------| | emp_id | name       | occupation | |--------+------------+------------| |      1 | John Smith | Accountant | |      2 | Jane Doe   | Engineer   | |      3 | Jack Black | Funnyman   | |--------+------------+------------|   There are many more rows with more occupations.  I would like to get three employees (lets say) from each occupation.  Is there a way to do this without using a subquery?
Ocean modifier and foam data export? It is there any way to export the foam data generated from ocean modifier to use it in other render engine, like LuxRender? The manual says that the foam data is stored as vertex color data, but there isn't a way to access the vertexColor data. I know that can be accessed from Cycles from attribute's node. LuxRender supports vertex color and I tried to bake the texture to vertexColor and an image but only get a plain black texture. Number of $n^2\times n^2$ permutation matrices with a 1 in each $n\times n$ subgrid I found the following question in a paper I was trying to solve:  The following figure shows a $3^2 \times 3^2$ grid divided into $3^2$ subgrids of size $3 \times 3$. This grid has $81$ cells, $9$ in each subgrid.    Now consider an $n^2 \times n^2$ grid divided into $n^2$ subgrids of size $n \times n$. Find the number of ways in which you can select $n^2$ cells from this grid such that there is exactly one cell coming from each subgrid, one from each row and one from each column.  My try:  Since we have $n^2$ rows, $n^2$ columns and $n^2$ subgrids in total, we have to choose one and only one cell from each of them. Let's choose them one at a time. We can choose the first cell in $n^4$ many ways. Then, we'll have to avoid that subgrid, that column and that row that we've chosen the first one from when choosing the second cell. So, we have $n^4-n^2-2n(n-1)$ choices. We can continue this to get the total number of possible ways. But, I think there's a hole. Say, we've chosen the first cell from the subgrid of the up-left corner and the second from the subgrid just right to it so that it doesn't violate any rules. Then, when finding the number of ways we can choose the third cell, we would have substracted some of the cells twice. I think you get it. Please, if anyone can help me solving this problem, it'd be greatly appreciated. If $\gcd(a,b)=1$, then there exists integers $x$ and $y$ such that $xa + yb = 1$ Night's Watch deserters are sentenced to death, as we've seen in the very first episode of Game of Thrones. A man dressed all in black is apprehended by Stark men and brought before Lord Eddard Stark. Lord Stark sees him as a deserter and sentences him to die (and then executes that death penalty).  However, there are men of the Night's Watch south of the Wall, on a legitimate mission or on some kind of allowed leave. For instance, we have Benjen Stark visiting Winterfell when the king and his party is there. There is also Yoren, who travels around Westeros in search of new recruits.  I could imagine that the Warden of the North (and other lords in the northern part of Westeros) would have a good idea of who would be allowed further south and whose appearance would raise suspicion. But I reckon the southern lords don't have as many visits from the Night's Watch, so they might not know who would be allowed to be there and who wouldn't.  How would lords who are rather unfamiliar with the specific brothers of the Night's Watch discern deserters from brothers sent out for some reason?  That ends my question, but there is a spoiler from the season 5 finale that continues the question a bit more:      Sam is sent to Oldtown to become a Maester, so he can replace Maester Aemon at Castle Black.  But he is riding together with Gilly (a woman!) and her baby (a baby!), which might raise a lot of suspicion from people who don't know what he is sent out to do.  What prevents southern lords of sentencing Sam as a deserter from the Night's Watch? Of course most languages have library functions for this, but suppose I want to do it myself.  Suppose that the float is given like in a C or Java program (except for the 'f' or 'd' suffix), for example "4.2e1", ".42e2" or simply "42". In general, we have the "integer part" before the decimal point, the "fractional part" after the decimal point, and the "exponent". All three are integers.  It is easy to find and process the individual digits, but how do you compose them into a value of type float or double without losing precision?  I'm thinking of multiplying the integer part with 10^n, where n is the number of digits in the fractional part, and then adding the fractional part to the integer part and subtracting n from the exponent. This effectively turns 4.2e1 into 42e0, for example. Then I could use the pow function to compute 10^exponent and multiply the result with the new integer part. The question is, does this method guarantee maximum precision throughout?  Any thoughts on this? Title of 80's movie: future-era timetraveling humans go extinct and rescue/kidnap todays air crash victims What is the title of a 80's (i believe?) movie where humans in the far future are going extinct, and are aquiring new humans by going back in time to todays world, kidnapping air travelers that are known to have died that day, from the flying passenger aircraft just before its crashing.  A key visual:    Inside a hangar, a time portal opened, and a tail of a (flying) passenger aircraft extruded into the hangar where a stairs provided access to the back door of the aircraft.  The kidnappers made sure the surviving passengers remain seated and would forget about the whole ordeal. Kidnapped humans got replaced by lookalike dummies, including things they had on them. They tried hard not to alter the timeline. Do the 46 human chromosomes form a single unbroken DNA helix?  Or is it rather that a human's genome consists of 46 disconnected helices?    If it is the former, does the common numbering scheme for the chromosomes have any correlation to their actual ordering in the one large strand?  If is the latter, is there a convention on how the chromosomes are ordered in genomic datasets?  Also, is there a clear understanding of how sister chromosomes "find" each other in Meiosis I?  Generally, during periods when Mitosis/Meiosis are not occurring,  what's a good physical picture for how the chromosomes are physically arranged (e.g. a bowl of 46 spaghetti noodles, or maybe the sister chromosomes always stay close together, etc)  thanks! Selecting features that do NOT intersect in ArcGIS Desktop? Animated textures don't work in Blender viewport playback Removing overlapping/duplicate polygons in same layer using QGIS? Starting scheduled task by detecting connection of USB device I know it has been discussed that it is not possible to start an application from an usb drive upon connection due to limitations of autorun (or autoplay??) in Win 7. But it is possible to create a scheduled task having an event type trigger. Surely there must be an event occurring when the drive -- or any USB device, for that matter -- is connected.    Does anybody have the slightest idea which Event ID should I use? Or at least what type of event? Where can I find the event in event viewer? I've got a weird question. Assume that you have a small sample where the dependent variable that you're going to analyze with a simple linear model is highly left skewed. Thus you assume that $u$ is not normally distributed, because this would result in normally distributed $y$. But when you compute the QQ-Normal plot there is evidence, that the residuals are normally distributed. Thus anyone can assume that the error term is normally distributed, although $y$ is not. So what does it mean, when the error term seems to be normally distributed, but $y$ does not? Evaluate the integral $\int^{\frac{\pi}{2}}_0 \frac{\sin^3x}{\sin^3x+\cos^3x}\,\mathrm dx$. Evaluate the integral $$\int^{\frac{\pi}{2}}_0 \frac{\sin^3x}{\sin^3x+\cos^3x}\, \mathrm dx.$$  How can i evaluate this one? Didn't find any clever substitute and integration by parts doesn't lead anywhere (I think).  Any guidelines please? Has anyone used PostgreSQL with PostGIS successfully?   I am a semi-experienced ArcGIS user and want to build out a database and connect it to ArcCatalog.   I've scoured the internet for resources but nobody has really given a good walkthrough. What is the minimum $ \sigma$-algebra that contains open intervals with rational endpoints What are the minimum $\sigma$-ring and $\sigma$-algebra on $\mathbb R$ which contain the open intervals with rational endpoints?  Is there a relation between this $\sigma$-algebra and Borels? How do I disable X at boot time so that the system boots in text mode? Is it possible to disable X at boot time? I'm setting up a server so it would be nice if it wouldn't load the graphical interface every time I boot. A pseudometric on the space of the measurable functions is complete Restricted logins with automatic full permission in databases My scenario: I have some groups with full - and inappropriate - access to all Sql Server instances. I want to change that.  My Plan: Give full and automatic access to all databases (it is customer databases and this groups must be allowed to change any property if necessary).  Restrict permissions on Instance Level, because this groups should not be allowed to do any unexpected change on instance properties.  I don't want to create a user in databases, because our external customer could drop the user ( they have db_owner permission )  Someone have any idea? Tks I want to trace a border in a box or minipage like this model. A border customizable in left angle on top and right angle in bottom. Somebody can help me? Thanks a lot JPierre My friend, John, and I went shopping.    My friend John and I went shopping.       I believe we need to wrap our friend's name in commas (first sentence example), but wouldn't that make it three people?