power(10,decimal(int(dcml_from) - int(dcml_to),13,5)) as dcml_derived
with
temp1 as (select pub_name, max(c_price) as maxprice
from book group by pub_name),
temp2 as (select pub_name, maxprice from temp1
where maxprice = (select max(maxprice) from temp1) )
select case when t.maxprice = t2.maxprice then '*' else '' END,
k.pub_name, isbn, author, title, c_price
from book k, temp1 t , temp2 t2
where k.pub_name = t.pub_name and
k.c_price = t.maxprice
order by k.pub_name;
source: http://www.cs.newpaltz.edu/~pletcha/DB/db2_TempTables.html
http://www.autoitscript.com/autoit3/index.shtml
; hot key for exit
HotKeySet("^!x", "MyExit")
;move mouse to click
$i = 1
While $i <= 361
MouseClickDrag ( "left", 191, 652, 412, 408 )
Sleep ( 1500)
$i = $i + 1
WEnd
; Exit
Func MyExit()
Exit
EndFunc
Hope you enjoy them.
http://mysite.verizon.net/Graeme_Birchall/id1.html
Don't miss out the great photos from here.
select * from file
where indate >=
date(curdate() - day(curdate()) days + 1 day)
where indate >=
date(curdate() - day(curdate()) days + 1 day)
