View gist:ce7d221b00789ae6c8ee69b7f56ed90c
//class | |
var package = function (packageName, originLatitude, originLongitude, | |
destinationLatitude, destinationLongitude) { | |
return { | |
packageName : packageName, | |
origin : { type : "Point", coordinates: [originLatitude, originLongitude]}, | |
destination : { type : "Point", coordinates: [destinationLatitude, destinationLongitude]} | |
}; | |
}; |
View duplicate.sql
select column_name, count(column_name) | |
from table | |
group by column_name | |
having count (column_name) > 1; |
View pagination.sql
SELECT * | |
FROM (SELECT R.*, ROWNUM RNUM, COUNT(*) OVER () RESULT_COUNT | |
FROM (SELECT i.ITEM_CODE, i.ITEM_NAME | |
FROM TBL_ITEMS i) R) | |
WHERE RNUM between 0 and 9 ; |