NeverLift

I don't believe any of these responses are valid. ROWID is not an ascending sequential number assigned to the rows as they are created. Rather, it is a composite value that identifies where a row resides, starting with the database segment (if appropriate for the database involved), then the "file …

Unworthy of a post. You need basic Oracle training.

Combining data from an indefinite number of rows into single rows in not a natural RDB issue and, in fact, is the antithesis of RDB philosophy. That being said: You will need to write a PL/SQL function, retrieve its string output for each distinct Policy No value in the table. …

Need a bit of clarification: If there are multiple rows with the same col1 and equal to the max on col3, do you want both to appear if they are not complete duplicates (col2 differs)? If just one, how should it be chosen? If you want all: If those rows …

As a beginner, it is absolutely essential that you obtain Oracle reference material. This system is not something that you learn as you go without wasting literally hundreds, probable thousands, of hours. Worse, you could easily create a collection of tables and views that run, but that do so so …

The question is ambiguous, please clarify: Do you want all whose leave period totally encompasses the desired period, or all whose leave period includes any part (including just one day) of the desired period? I have an algorithm (about 30 years old ;) ) I created for the latter, a …

Assuming the number of table rows for each "record" varies: This is not easily accomplished -- if at all -- with SQL. Even if the number is fixed, it's still messy. You'll have to program it in PL/SQL, or in the code that is accessing Oracle.

I don't have an Oracle instance to test this on, but I believe the following will work: [code] select sr_no,Supplier_id,weight from example_table, (select Supplier_id sudmax, max(weight) wtmax from example_table group by Supplier_id) where Supplier_id=sudmax and weight=wtmax order by sr_no; [/code] If it happens that your table content has suppliers grouped …