'round' key word in llblgen

Posts   
 
    
PAZIMLI
User
Posts: 82
Joined: 01-May-2008
# Posted on: 20-Oct-2008 10:56:10   

llblgen pro v2.5 Adapter Oracle 10g, SqlServer 2000 C#.Net 2005

Hi,

select item_kodu,round(sum(lot_miktar),2) from seri_no group by item_kodu order by sum(lot_miktar) desc

how can I write above sql statement by llblgen.

I do not know the llblgen syntax for 'round' key word. thanks.

Walaa avatar
Walaa
Support Team
Posts: 14946
Joined: 21-Aug-2005
# Posted on: 20-Oct-2008 10:57:11