I have getting this error “Expression must be a group key or aggregate: (t
.aadharNo
)”,
“query_from_user”: “select t.aadharNo as ad,count(t)as count from tablet where t.title=‘users’ LIMIT 5”
here is my query,is there any wrong?
"select t.aadharNo as ad,count(t)as count from table t where t.title=‘users’ LIMIT 5’;
Example document:
{
“id”: “123456gg55d”,
“Name”: “Jane”,
“aadharNo”: “12344534566”,
“age”: “26”,
}