supported sql

[joshua]

does symbian database library support things like count(*) , group by ? From the 6.1 and 7.0 sdk doc the supported sql subset looks rather limited

[alwin2]

group by and ordere by is well.
Do you know what I've to write when I will defin a "where" condition and working with variables, eg

select... from table
where nr = :nr

If I write
.... where nr = 1

it's well...