Jump to content
We've recently updated our Privacy Statement, available here ×

2503686606

Members
  • Posts

    2
  • Joined

  • Last visited

2503686606's Achievements

Newbie

Newbie (1/14)

  • Week One Done
  • One Month Later
  • One Year In
  • First Post Rare
  • Conversation Starter Rare

Recent Badges

0

Reputation

  1. I have a problem here, if any there parameters is null, eg, select entry.date, entry.msisdn, entry.content from entry where entry.date = null and entry.date = $P{dateTo},How can I get the result set for entry.date = $P{dateTo}
  2. SELECT * FROM TABLE WHERE A = X AND B = Y; When A = X and B = null, I hope to query out ALL RECORDS for 'X', accordingly, when A = null and B = Y,I hope to query out ALL RECORDS for 'Y'.How to make it happen ?
×
×
  • Create New...