I had to do some basic analysis of email addresses at my company the other day.\u00ac\u0086 Here are a few useful SQL queries.<\/p>\n
Show 10 records with the most data in field ’email’ (10 longest email addresses) I had to do some basic analysis of email addresses at my company the other day.\u00ac\u0086 Here are a few useful SQL queries. Show 10 records with the most data in field ’email’ (10 longest email addresses) SELECT TOP 10 email, LEN(email) AS fieldLength FROM person ORDER BY fieldLength DESC Count all records with field … Read more<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"_cloudinary_featured_overwrite":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[68],"tags":[12,16],"class_list":["post-49","post","type-post","status-publish","format-standard","hentry","category-developer","tag-developer","tag-sql"],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/pbVg43-N","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/csimmons.dev\/blog\/wp-json\/wp\/v2\/posts\/49","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/csimmons.dev\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/csimmons.dev\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/csimmons.dev\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/csimmons.dev\/blog\/wp-json\/wp\/v2\/comments?post=49"}],"version-history":[{"count":0,"href":"https:\/\/csimmons.dev\/blog\/wp-json\/wp\/v2\/posts\/49\/revisions"}],"wp:attachment":[{"href":"https:\/\/csimmons.dev\/blog\/wp-json\/wp\/v2\/media?parent=49"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/csimmons.dev\/blog\/wp-json\/wp\/v2\/categories?post=49"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/csimmons.dev\/blog\/wp-json\/wp\/v2\/tags?post=49"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\n
\nSELECT TOP 10 email, LEN(email) AS fieldLength
\nFROM person
\nORDER BY fieldLength DESC
\n<\/code>
\nCount all records with field ’email’ over 20 chars
\n
\nSELECT COUNT(*) AS emailOver20
\nFROM person
\nWHERE LEN(email) > 20
\n<\/code>
\nDisplay the average length of data (in characters) of field ’email’
\n
\nSELECT AVG(LEN(email)) AS emailAvgLength
\nFROM person
\n<\/code><\/p>\n","protected":false},"excerpt":{"rendered":"