searock

//class
var package = function (packageName, originLatitude, originLongitude,
    destinationLatitude, destinationLongitude) {
    return {
        packageName : packageName,
        origin : { type : "Point", coordinates: [originLatitude, originLongitude]},
        destination : { type : "Point", coordinates: [destinationLatitude, destinationLongitude]}

    };
};

searock

select column_name, count(column_name)
from table
group by column_name
having count (column_name) > 1;

searock

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 ;