• Post Reply Bookmark Topic Watch Topic
  • New Topic

sql query  RSS feed

 
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
 
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 .........................
 
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?
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!