SQL Professionals of Chattanooga

Next Meeting

Friday,

August

30

The Function of Windowing Functions

  • In-Person @ 1100 Market Street Chattanooga, Tennessee, United States (map)
  • 12:00 - 13:00 Eastern Daylight Time
  • Language: English

Join us as Kevin Wilikie talks about Windowing Functions.

Register Here

Featured Presentation:

The Function of Windowing Functions

Kevin Wilkie, Data Sherpa IntegraConnect

In the past, we have all had the need to return a result set and provide information on this with regard to a persons previous or future records. Or, alternatively, you have needed to get a single record for an individual - maybe the first maybe the last. Doing this without windowing functions is possible but why punish yourself?! Come to learn about general windowing functions that we should all know, as well as some that you may not be aware of! Did you know you can use count(*) as a windowed function in addition to general aggregate?

About Kevin:
Kevin has 15+ years experience with SQL Server and has worked with the product since version 6.5, although he remembers with distaste the early versions of the product. He started working with SQL Server as an "Accidental" DBA, and has moved up through the ranks as a SQL Developer, a BI Associate, and Production DBA at various parts of his career. Currently, he works as a Lead Data Analyst spreading the gospel of how great data can be to anyone and everyone who will listen.

PASSChapterLogo.jpg

sql_micro_sm.gif

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids