How to get RowCount on MySQL?

Hello Hector

windows function!

Select field1, fiel2, field3, count(*) OVER() As row_count
From MyTable
where field1= ‘1760’

Regards
Mauricio