VB.NET:SELECT statement with COUNT expression?

S

Someone

New member
i use query "SELECT Phone, COUNT(*)AS NoOfBook FROM borrow WHERE DueDate = '" & Me.lblremindate.Text & "'GROUP BY Phone" to display Phone and NoOfBook in DataGridView.

i want to display 1 more column from same table which is StudentID.

I try this query:
SELECT StudentID, Phone, COUNT(*)AS NoOfBook FROM borrow WHERE DueDate = '" & Me.lblremindate.Text & "'GROUP BY Phone....but error..

Anyone can help me please...:((
 
Back
Top