NeverLift

I am looking for query to select the last row of a table. Please help.

I had a small issue. Can you pls check this... I have two tables TABLEA,TABLEB. TABLEA -------------- col1 col2 col3 TABLEB -------------- cl1 cl2 cl3 If col2 in TABLEA = cl2 in TABLEB, then i need to update cl3 in TABLE B with col3 in TABLE A. I tried running …

Hi, I am working on a report where I need to split the rows and update put it on a different column. For e.g. Policy No DriverName 123 John 123 David 124 Matt 125 Phil 125 Peter I need to split the data as per the policy number and instead …

I need a query that will find for example in the given table Distinct Col1, with highest Col3 [CODE]A X 1 A Y 2 A X 3 B Y 2 B Z 4[/CODE] So the result should be: [CODE]A X 3 B Z 4[/CODE]

hi... I am beginner for Oracle. Please anyone can tell me how we can assign primary key in to a particular field???????

Hi, I have oracle table for Leave LeaveNo FromDt ToDt 1 01/01/2010 31/03/2010 2 01/02/2010 31/05/2010 3 01/04/2010 30/04/2010 4 25/04/2010 15/05/2010 5 01/05/2010 31/05/2010 I want find out who was leave on 01/04/2010 to 30/04/2010. how to write oracle sql? tks in advance kartheeee

Hi, I have a table, which contains multiple rows for a single set of records. It looks like - pk Value ValueType 1 123 XXXX 1 234 YYYY 1 345 ZZZZ 2 1234 XXXX 2 2341 YYYY 2 2345 ZZZZ The pk + Value + ValueType will be unique. I …

I need a little help with a query . I have attached an example table (roughly) in attached picture. The table has a serial number, a supplier_id and a weight column. We need to retrieve FOR each supplier the row that has maximum weight. There could be duplicate rows if …