{"id":782,"date":"2013-06-26T10:40:07","date_gmt":"2013-06-26T03:40:07","guid":{"rendered":"http:\/\/blog.kusumoto.co\/?p=782"},"modified":"2013-06-26T10:40:07","modified_gmt":"2013-06-26T03:40:07","slug":"mssql-lab-test-1","status":"publish","type":"post","link":"https:\/\/oldblog.kusumotolab.com\/?p=782","title":{"rendered":"MSSQL Lab Test 1"},"content":{"rendered":"<pre lang=\"sql\">\r\n\/*1*\/\r\nselect CompanyName AS '\u0e0a\u0e37\u0e48\u0e2d\u0e1a\u0e23\u0e34\u0e29\u0e31\u0e17' from Customer_data ;\r\n\r\n\/*2*\/\r\nselect CompanyName,Country from Customer_data WHERE Country='Germany';\r\n\r\n\/*3*\/\r\nselect * from Customer_data WHERE Payment BETWEEN 1 AND 20 ORDER BY Country DESC;\r\n\r\n\/*4*\/\r\nselect DISTINCT Country from Customer_data;\r\n\r\n\/*5*\/\r\nselect CompanyName,ContectName,Region from Customer_data WHERE Region is not NULL;\r\n\r\n\/*6*\/\r\nselect CompanyName,ContectName,Contectitle from Customer_data WHERE Contectitle='Sales Representative';\r\n\r\n\/*7*\/\r\nselect * from Customer_data WHERE Country='USA' AND Payment>=7;\r\n\r\n\/*8*\/\r\nselect CustomerID,CompanyName,ContectName from Customer_data WHERE CompanyName Like '%a'\r\n\r\n\/*9*\/\r\nselect * from Customer_data WHERE City in ('London','Helsinki') ORDER BY City ASC;\r\n\r\n\/*10*\/\r\nselect CustomerID,CompanyName,Region,Country,Payment from Customer_data WHERE Payment != 15  AND Region is NULL ORDER BY Country ASC\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\/*1*\/ select CompanyName AS &#8216;\u0e0a\u0e37\u0e48\u0e2d\u0e1a\u0e23\u0e34\u0e29\u0e31\u0e17&#8217; from Customer_data ; \/*2*\/ select CompanyName,Country from Customer_data WHERE Country=&#8217;Germany&#8217;; \/*3*\/ select * from Customer_data WHERE Payment BETWEEN 1 AND 20 ORDER BY Country DESC; \/*4*\/ select DISTINCT Country from Customer_data; \/*5*\/ select CompanyName,ContectName,Region from Customer_data WHERE Region is not NULL; \/*6*\/ select CompanyName,ContectName,Contectitle from Customer_data WHERE Contectitle=&#8217;Sales Representative&#8217;; \/*7*\/ [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"footnotes":"","jetpack_publicize_message":"","jetpack_is_tweetstorm":false,"jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":[]},"categories":[60,9],"tags":[],"class_list":["post-782","post","type-post","status-publish","format-standard","hentry","category-mssql","category-private"],"jetpack_publicize_connections":[],"aioseo_notices":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p3OMEb-cC","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/oldblog.kusumotolab.com\/index.php?rest_route=\/wp\/v2\/posts\/782","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/oldblog.kusumotolab.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/oldblog.kusumotolab.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/oldblog.kusumotolab.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/oldblog.kusumotolab.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=782"}],"version-history":[{"count":3,"href":"https:\/\/oldblog.kusumotolab.com\/index.php?rest_route=\/wp\/v2\/posts\/782\/revisions"}],"predecessor-version":[{"id":785,"href":"https:\/\/oldblog.kusumotolab.com\/index.php?rest_route=\/wp\/v2\/posts\/782\/revisions\/785"}],"wp:attachment":[{"href":"https:\/\/oldblog.kusumotolab.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=782"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oldblog.kusumotolab.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=782"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oldblog.kusumotolab.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=782"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}