sql - Copy the Result Set Into another table -


i want copy result set of query table using java:

 select basescore, count(*) log   group basescore     ;;;;;suppose________into log2 log

i have tried lot gives me errors can please. in advance!

try way:

select basescore, count(*) cnt  log2 log      group basescore

Comments

Post a Comment

Popular posts from this blog

PHP Error "Undefined index" -

hello i'm trying login system working on site , error saying notice: undefined index: user_login in c:\wamp\www\justbetweenfriends\home.php on line 4 . the database works , everthing else works besides error i'm getting now. home.php code <?php error_reporting(e_all ^ e_deprecated); ?> <?php include ( "./inc/header.inc.php" ); echo $_session["user_login"]; ?> full code index.php <?php error_reporting(e_all ^ e_deprecated); ?> <?php include( "./inc/header.inc.php" ); ?> <?php $reg = @$_post['reg']; //declaring variables prevent errors $fn = ""; //first name $ln = ""; //last name $un = ""; //username $em = ""; //email $em2 = ""; //email 2 $pswd = ""; //passoword $pswd2 = ""; // password 2 $d = ""; // sign data $u_check = ""; // check if username extsts //registration form $fn = strip_tags(@$_post...
Read more

C# List<> to xml -

calling list<pc> _pclist = new list<pc>(); ...add pc pclist.. writexml<list<pc>>(_pclist, "ss.xml"); function public static void writexml<t>(t o, string filename) { string filepath= environment.getfolderpath(environment.specialfolder.applicationdata) + "\\genweb2\\adsnopper\\" + filename; xmldocument xmldoc = new xmldocument(); xpathnavigator nav = xmldoc.createnavigator(); using (xmlwriter writer = nav.appendchild()) { xmlserializer ser = new xmlserializer(typeof(list<t>), new xmlrootattribute("therootelementname")); ser.serialize(writer, o); // error } file.writealltext(filepath,xmldoc.innerxml); } inner exception unable cast object of type 'system.collections.generic.list 1[pc]' type 'system.collections.generic.list 1[system.collections.generic.list`1[pc]]'. please help the problem line xmlserializer ser = new xmlserializ...
Read more

css - Code reuse with LESS -

so, i'm in project. have running application same clients have. thing changes, little bit of (pure) css. big problem, each page, have css stylesheet, , each client, have same sheet, specific changes made. i'm thinking on way reduce redundant code, , starting use css precompiler @ same time, ease our development process, less. have ground rules, are: code refactoring bad idea, it's many code , not worth it the final css filesize cannot bigger, our sites have heavy traffic my first idea, write precompiler enables "extending" sheets, extending view, blocks , stuff ( like this ), , write little script diffs files , automatically extends it, , creates file differences only, this: /** @extends: site/home/test */ #square-test { background: #c00; } but seems complicated, , little bit messy. has been same situation? how did guys handle it? has ideas? i'm thankful help. edit: i'm using regular lamp, php 5.3.newer. you can use sas...
Read more