• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

sql query

 
Shanky Sohar
Ranch Hand
Posts: 1051
Eclipse IDE Firefox Browser
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
"SELECT QC_CHRG_RATE, QC_LKP_SA FROM QC_CHRG_RATE WHERE QC_RATE_TBL = " + rateTableID +
" AND QC_RATE_TBL_EFF_DT = '" + effDate.getDBFormattedDate() +
"' AND QC_LKP_KEY = '" + lookupKey +
"' AND QC_LKP_AGE2 >= " + lookupAge +
" AND QC_LKP_CLMN_NUM >= " + lookupColumn +
" ORDER BY QC_LKP_AGE2 ASC, QC_LKP_CLMN_NUM ASC";


how this SQL will run
 
Fatih Keles
Ranch Hand
Posts: 182
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi shanky,

What do you mean by "run"? Are you asking for output, execution plan, logic? Or just how to run it? Can you provide more information about your question, database etc ?

Regards,

Fatih.
 
Shanky Sohar
Ranch Hand
Posts: 1051
Eclipse IDE Firefox Browser
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
i wanna know how thw output will be evaluated .........................
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
shanky sohar wrote:i wanna know how thw output will be evaluated .........................


Not sure what you mean here. Can you explain some more?
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic