delete from tablename where id not in ( select min(id) from tablename group by column1 , column2 ,column3)
example
DELETE FROM DAILY_ATTENDANCE
WHERE ATT_ID NOT IN
( SELECT MIN(ATT_ID)
FROM DAILY_ATTENDANCE
GROUP BY STAFF_ID, TIME_IN, TIME_OUT
)
*************************************DATABASE CREATION*********************************************************************************************** DOWNLOAD LIFERAY PORTAL SCRIPTS FROM https://www.liferay.com/downloads/liferay-portal/available-releases Rename the file as liferay.sql put it let say in under c drive , so it will be located like this c:\liferay.sql from cmd dir c:\ SQLPLUS / AS SYSDBA @liferay.sql lportal lportal it will create the db ..after finishing go to sqlplus again to ggrant the below to lportal user SQLPLUS / AS SYSDBA grant create session to lportal; grant connect to lportal; grant resource to lportal; *******************************CONFIGURE WILDFLY TO CONNECT TO ORACLE DB ***************************************************************************************************** configure wildfly to connect to oracle db Download the driver: ojdbc[VERSION].jar Create subfolders [WILDFLY_HOME]/modules/system/layers/base/com/o...
Comments
Post a Comment