അനർഗള നിർഗള പ്രവാഹം
  • ബഹിർസ്പുരണങ്ങൾ
  • Note Book
  • Family History
  • ബഹിർസ്പുരണങ്ങൾ
  • Note Book
  • Family History
Search by typing & pressing enter

YOUR CART

7/22/2013 1 Comment

SQL RANK() function Example

   SELECT p.version, p.launch_date
   RANK() OVER (PARTITION BY p.version
   ORDER BY p.launch_date DESC) "Rank"
   FROM product p WHERE p.id = '1234'
Picture
1 Comment

7/22/2013 0 Comments

SQL: Select the minimum and maximum values of a column grouped by another column for a given where clause.

select   p.version, min (p.launch_date) as first, max(v.launch_date) as last
from product p
where p.id = '1234'
group by p.version, p.id
order by  p.version

The above query selects the first and last launch dates for every version (major version number assumed) of a given product with id 1234
Picture
0 Comments

7/12/2013 1 Comment

How to stop JiBX from marshalling empty nodes for null fields on structure mapping

Use a test-method on the structure to return false if the field value is null.
Note: This can be applied only when the usage attribute is set to optional (ie. usage="optional")

E.g.

<structure name="CreditCard" field="creditCard"  usage="optional" test-method="hasValidCredtiCard">
    <value name="CardNumber" field="number" usage="optional"/>
    <value name="ValidThru" get-method="getValidThru" set-method="setValidThru" usage="optional"/>
    <value name="NameOnCard" field="name" usage="optional"/>
    ....
</structure>
1 Comment

    Archives

    July 2016
    October 2013
    July 2013
    June 2013

    Categories

    All

    RSS Feed

Powered by Create your own unique website with customizable templates.