http://in.compucrete.com/index.php?action=history&feed=atom&title=General_Ledger_Delete_Unused_Groups_Query
General Ledger Delete Unused Groups Query - Revision history
2026-05-15T17:02:57Z
Revision history for this page on the wiki
MediaWiki 1.40.0
http://in.compucrete.com/index.php?title=General_Ledger_Delete_Unused_Groups_Query&diff=246&oldid=prev
WikiAdmin: 1 revision imported
2023-07-14T12:58:50Z
<p>1 revision imported</p>
<table style="background-color: #fff; color: #202122;" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 12:58, 14 July 2023</td>
</tr>
<!-- diff cache key my_wiki:diff::1.12:old-245:rev-246 -->
</table>
WikiAdmin
http://in.compucrete.com/index.php?title=General_Ledger_Delete_Unused_Groups_Query&diff=245&oldid=prev
Intra>User: 1 revision imported
2017-01-10T00:01:44Z
<p>1 revision imported</p>
<p><b>New page</b></p><div><br />
Preview with select query:<br />
<PRE><br />
Select * from gltacgrp g<br />
where not exists<br />
( select * from gltacct a where a.gl_group = g.group_id)<br />
and not exists<br />
( select * from gltacgrp g2 where g2.parent_group_id = g.group_id)<br />
</PRE><br />
<br />
<br />
<PRE><br />
DELETE from gltacgrp g<br />
where not exists<br />
( select * from gltacct a where a.gl_group = g.group_id)<br />
and not exists<br />
( select * from gltacgrp g2 where g2.parent_group_id = g.group_id)<br />
</PRE></div>
Intra>User