Drop files here

SQL upload ( 0 ) x -

Page-related settings Click on the bar to scroll to top of page
Press Ctrl+Enter to execute query Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count : Time taken :
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Options
Set default





Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database : Queried time :
Browse mode
Customize browse mode.
Browse mode
Documentation Use only icons, only text or both. Restore default value
Documentation Use only icons, only text or both. Restore default value
Documentation Whether a user should be displayed a "show all (rows)" button. Restore default value
Documentation Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown. Restore default value
Documentation SMART - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise. Restore default value
Documentation Highlight row pointed by the mouse cursor. Restore default value
Documentation Highlight selected rows. Restore default value
Documentation Restore default value
Documentation Restore default value
Documentation Repeat the headers every X cells, 0 deactivates this feature. Restore default value
Documentation Maximum number of characters shown in any non-numeric column on browse view. Restore default value
Documentation These are Edit, Copy and Delete links. Restore default value
Documentation Whether to show row links even in the absence of a unique key. Restore default value
Documentation Default sort order for tables with a primary key. Restore default value
Documentation When browsing tables, the sorting of each table is remembered. Restore default value
Documentation For display Options Restore default value
SELECT * FROM `job_duties` ORDER BY `kra_id` DESC 
Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
Full texts id kra_id Descending Ascending 1 duty_description
Edit Edit Copy Copy Delete Delete
DELETE FROM job_duties WHERE `job_duties`.`id` = 1196
1196 338 Perform other functions as may be assigned by the ...
Edit Edit Copy Copy Delete Delete
DELETE FROM job_duties WHERE `job_duties`.`id` = 1190
1190 337 Assist in the preparation of Inspection Order to b...
Edit Edit Copy Copy Delete Delete
DELETE FROM job_duties WHERE `job_duties`.`id` = 1191
1191 337 Monitor and evaluate the actual conduct of procure...
Edit Edit Copy Copy Delete Delete
DELETE FROM job_duties WHERE `job_duties`.`id` = 1192
1192 337 Monitor compliance of the procurement process with...
Edit Edit Copy Copy Delete Delete
DELETE FROM job_duties WHERE `job_duties`.`id` = 1193
1193 337 Maintain and update the procurement tracking syste...
Edit Edit Copy Copy Delete Delete
DELETE FROM job_duties WHERE `job_duties`.`id` = 1194
1194 337 Administer planned activities relative to monitori...
Edit Edit Copy Copy Delete Delete
DELETE FROM job_duties WHERE `job_duties`.`id` = 1195
1195 337 Participate in the initiation of sanctions against...
Edit Edit Copy Copy Delete Delete
DELETE FROM job_duties WHERE `job_duties`.`id` = 1187
1187 336 Administer the implementation and administration o...
Edit Edit Copy Copy Delete Delete
DELETE FROM job_duties WHERE `job_duties`.`id` = 1188
1188 336 Coordinate with the ProcMS-Contract Management Div...
Edit Edit Copy Copy Delete Delete
DELETE FROM job_duties WHERE `job_duties`.`id` = 1189
1189 336 Coordinate with end-users for the acceptance of th...
Edit Edit Copy Copy Delete Delete
DELETE FROM job_duties WHERE `job_duties`.`id` = 1179
1179 335 Review and oversee the procurement process from pr...
Edit Edit Copy Copy Delete Delete
DELETE FROM job_duties WHERE `job_duties`.`id` = 1180
1180 335 Supervise the actual conduct of procurement activi...
Edit Edit Copy Copy Delete Delete
DELETE FROM job_duties WHERE `job_duties`.`id` = 1181
1181 335 Organize procurement documents for presentation an...
Edit Edit Copy Copy Delete Delete
DELETE FROM job_duties WHERE `job_duties`.`id` = 1182
1182 335 Prepare procurement timelines or schedules, minute...
Edit Edit Copy Copy Delete Delete
DELETE FROM job_duties WHERE `job_duties`.`id` = 1183
1183 335 Post and/or advertise request for quotations, invi...
Edit Edit Copy Copy Delete Delete
DELETE FROM job_duties WHERE `job_duties`.`id` = 1184
1184 335 Oversee the sale and distribution of bidding docum...
Edit Edit Copy Copy Delete Delete
DELETE FROM job_duties WHERE `job_duties`.`id` = 1185
1185 335 Oversee the dissemination of procurement documents...
Edit Edit Copy Copy Delete Delete
DELETE FROM job_duties WHERE `job_duties`.`id` = 1186
1186 335 Gather data and assist in the preparation of the m...
Edit Edit Copy Copy Delete Delete
DELETE FROM job_duties WHERE `job_duties`.`id` = 1175
1175 334 Assist the end-user units in the preparation of th...
Edit Edit Copy Copy Delete Delete
DELETE FROM job_duties WHERE `job_duties`.`id` = 1176
1176 334 Conduct quarterly end-user interface
Edit Edit Copy Copy Delete Delete
DELETE FROM job_duties WHERE `job_duties`.`id` = 1177
1177 334 Plan, prioritize and coordinate tasks with BAC & ...
Edit Edit Copy Copy Delete Delete
DELETE FROM job_duties WHERE `job_duties`.`id` = 1178
1178 334 Assist and review PPMPs and other procurement docu...
Edit Edit Copy Copy Delete Delete
DELETE FROM job_duties WHERE `job_duties`.`id` = 1174
1174 333 Submit end of the day report
Edit Edit Copy Copy Delete Delete
DELETE FROM job_duties WHERE `job_duties`.`id` = 1172
1172 332 Deter and detect unlawful activity
Edit Edit Copy Copy Delete Delete
DELETE FROM job_duties WHERE `job_duties`.`id` = 1173
1173 332 Respond to alarm and respond on time
With selected: With selected:
Query results operations Copy to clipboard Copy to clipboard Export Export Display chart Display chart Create view Create view
Bookmark this SQL query Bookmark this SQL query