aspose file tools*
The moose likes JDBC and the fly likes sql query Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "sql query" Watch "sql query" New topic
Author

sql query

Shanky Sohar
Ranch Hand

Joined: Mar 17, 2010
Posts: 1051

"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


SCJP6.0,My blog Ranchers from Delhi
Fatih Keles
Ranch Hand

Joined: Sep 01, 2005
Posts: 182
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

Joined: Mar 17, 2010
Posts: 1051

i wanna know how thw output will be evaluated .........................
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

shanky sohar wrote:i wanna know how thw output will be evaluated .........................


Not sure what you mean here. Can you explain some more?


JavaRanch FAQ HowToAskQuestionsOnJavaRanch
 
Don't get me started about those stupid light bulbs.
 
subject: sql query