Code:
empid emplrcd effdt effsq 101 #1 2/1/99 0 101 #1 3/1/13 1 101 #1 23/3/13 1 101 #1 22/6/13 2 102 #2 20/6/91 1
Code:
select a* from Ps_Job a where a.empid = '101' and a.emprcd ='#1' and a.effdt = (select max(a1.effdt) from Psjob1)
prasanth22
Last Activity: Oct 10 '13, 05:23 AM
Joined: Oct 10 '13
Location:
-
prasanth22 started a topic Sql query - orcale database.. Need to retrieve a row with generic conditionin OracleSql query - orcale database.. Need to retrieve a row with generic condition
I need to retrieve row 4, and I have written a partial code, please help me with the other half.
...Last edited by Rabbit; Oct 10 '13, 05:33 AM. Reason: Please use [CODE] and [/CODE] tags when posting code or formatted data.
No activity results to display