Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
first and last items
say i do a select statement and I get 5 record sets returned. each record set has a different number of variables ie. r1 - xyz123, udf432, asf909, lkj011 r2 - kjf092, sdf092 r3 - dsf025, dsl985, fds986 r4 - sdf021 r5 - dsa349, fds543, xcv941, fiz091, fgs431, oiz012 what i'd like to do, is... -
-
Nested SQL Queries to achieve this?
Here's my dummy table: page ip mark pageA 127.0.01 n pageA 127.0.01 c pageB 128.42.52 n pageB 128.42.52 c pageB 128.42.52 c pageB 328.3.11 n pageB 328.3.11 c pageC 228.2.01 n i'd like to run a count(distinct ip), group by page but also be able to extract how many distinct by page...
