Hi friends,

I am stuck in solving the sql query.PI am not good at sql query,Please give me the solution ion this.

In my table, there are 3 fields say MainId, Name and parentId.
MainId is auto increment field and ParentId store the value of MainId.
a) Now I want to find the name and their parentId
b) Count of ParentId for the mainId.

How do I get in sql query.


Thanks & Regards

PPCC