Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mermaidhaven
Starting Member
9 Posts |
 Posted - 2001-11-08 : 12:15:53
|
| Is there a way I can tell how many rows of counts this will return from this group by stmt?select count(*) as recordcount, best_sat_verbal, best_sat_math, admit_term_code, coll_code, major_code, ethnic_code, aplcn_dcsn_flag, apct_dcsn_flag from sisbapp where aplcn_status_code <> 'pros' and apct_dcsn_code <> 'mstk' and entity_ctgry_code in ('H','') and aplcn_srce = 'E' and best_sat_verbal > 0 group by admit_term_code, major_code, ethnic_code, coll_code, aplcn_dcsn_flag, apct_dcsn_flag, best_sat_verbal, best_sat_mathIs there another query I can run that will give me this info?thankssam |
|
|
|
|
|
|
|
Group by row count