Geek Articles

Home |  Submit Article |  Submit Resource |  Submit RSS |  RSS |  Sitemap |  Contact Us  

Categories

 

Subscribe

Daily Updates Subscribe geekarticles update via email Subscribe geekarticles update via RSS

 
GeekArticles Database SQL Server

Computing the Trimmed Mean in SQL

Author: sqlteam.com | Published: 10th Aug 2005 | Visited: 723 times | Add Comment
Filed in: SQL Server

This article presents code to compute a trimmed mean in SQL. The trimmed mean is a more robust version of the simple mean (SQL AVG() aggregate function). It is a useful tool for summarizing ill-behaved real world data.

Read Article
 

Sponsored Links

 


Related Articles

• Microsoft Investing to Make High-Performance Computing Mainstream High-Performance Computing (HPC) has long exceeded the reach of the masses. In fact, I bet the mere mention of HPC conjures images in your mind of the Cray Supercomputer or HAL-9000. These supercomputers, along with their super-cost, have historically been play things for governments and academics. ...

• Hanoi Tower Non-Recursive computing Hanoi Tower Recursive & Non-Recursive compu ...

• IT in 2018: From Turing?s Machine to the Computing Cloud  ...

• IT in 2018: From Turing?s Machine to the Computing Cloud  ...

• IT in 2018: From Turing?s Machine to the Computing Cloud  ...

• Web Services Extend High-Performance Computing Grid Capabilities Grid computing based on Web services provides a compelling means for enterprises to create High-Performance Computing infrastructures. Adding to the inherent cost/performance advantages of grid networks based on Intel® Xeon® processors and/or Itanium® processors, building solutions from pre-existing ...

• Sentilla's Java-Technology Based Pervasive Computing Extending Java ME to the physical world, Sentilla enables Java software developers to interact with the world using low power microcontrollers, sensors, actuators, and wireless mesh network ...

• Article :: Social, Legal, and Ethical Issues in Computing: Professional Ethics and Responsibilities This chapter considers the ethics that a computer professional might encounter on the job and how to approach ethical dilem ...

• Article :: Social, Legal, and Ethical Issues in Computing: Errors, Failures, and Risk This chapter is about computer systems that fail, crash, or never work at ...

• HPC, the Message Passing Interface, and Microsoft: What You Need to Know to Control, Manage, and Com... With clustering on the rise and products like the Windows® Compute Cluster Server making HPC more accessible, understanding the message passing interface (MPI) in your high-performance cluster is critical for getting the most out of it. We detail what you need to know about MPI in general and the Mi ...



Next: .NET Rocks! - Brian Larson on SQL Server Reporting Services



Post Comment

Name:


Email:
 (Optional. Used for Notification)

Title:

 
Comment:


Validation Code:
 <=>  (Enter this code in text box)





Latest Articles

 ♦ Accessing and Updating Data in ASP.NET 2.0: Using Optimistic Concurrency
 ♦ Warning the User when Caps Lock is On
 ♦ Building Interactive User Interfaces with Microsoft ASP.NET AJAX: Providing Visual Feedback with the UpdateProgress Control
 ♦ Working with XML Data Using LINQ, a TreeView, and a ListView :: Editing Data
 ♦ Working with XML Data Using LINQ, a TreeView, and a ListView :: Displaying Data
 ♦ Examining ASP.NET's Membership, Roles, and Profile - Part 10
 ♦ Creating an Online Boggle Solver :: Solving the Puzzle
 ♦ Creating an Online Boggle Solver :: Building the User Interface
 ♦ Importing an Excel Spreadsheet Using Typed DataSets and TableAdapters: Importing the Excel Spreadsheet
 ♦ Importing an Excel Spreadsheet Using Typed DataSets and TableAdapters: Creating a Data Access Layer (DAL)
 

Popular Articles

 ♦ MSAS Step by Step Tutorials
 ♦ The Daily Database Build
 ♦ SQL Server 2005 Webcasts
 ♦ Data Cleansing Applications with SQL Server Integration Services
 ♦ Naming Database Objects: Part II
 ♦ Computing the Trimmed Mean in SQL
 ♦ SQL Tools Improve Response Time for National Victim Assistance Organization
 ♦ Tip: Using sp_addextendedproperty in order to add a property that's longer than 255 characters.
 ♦ Separator First Formatting (SFF)
 ♦ Trace Messages Part V: Trace Cleanup

Sponsored Links

 

About | Privacy | Submit Article | Submit Resource | Submit RSS | RSS |  Sitemap |  Contact Us
Copyright © geekarticles.com