{"id":"https://openalex.org/W626676288","doi":null,"title":"Practical SQL The Sequel","display_name":"Practical SQL The Sequel","alternate_titles":[],"publication_year":2000,"publication_date":"2000-11-01","ids":{"openalex":"https://openalex.org/W626676288","mag":"626676288"},"language":"en","primary_location":{"id":"mag:2254177225","doi":null,"is_oa":false,"landing_page_url":"http://dl.acm.org/citation.cfm?id=517448","pdf_url":null,"source":{"id":"https://openalex.org/S4306464808","display_name":"Addison-Wesley Longman Publishing Co., Inc. eBooks","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"ebook platform"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":"Addison-Wesley Longman Publishing Co., Inc. eBooks","raw_type":null},"parent_works":[],"lineage":["https://openalex.org/W626676288"],"child_works_count":0,"type":"book","is_traditional":true,"indexed_in":[],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5064318052","display_name":"Judith S. Bowman","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":true,"raw_author_name":"Judith S. Bowman","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":0,"corresponding_author_ids":["https://openalex.org/A5064318052"],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":1,"citation_normalized_percentile":{"value":0.0,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":null,"last_page":null},"is_retracted":false,"is_pulled":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.98580002784729,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.98580002784729,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T13681","display_name":"Engineering and Information Technology","score":0.007799999788403511,"subfield":{"id":"https://openalex.org/subfields/1712","display_name":"Software"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.0006000000284984708,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.7570000290870667},{"id":"https://openalex.org/keywords/sql-dialects","display_name":"SQL dialects","score":0.5899999737739563},{"id":"https://openalex.org/keywords/oracles","display_name":"oracles","score":0.5669999718666077},{"id":"https://openalex.org/keywords/t-sql","display_name":"T-SQL","score":0.722000002861023},{"id":"https://openalex.org/keywords/mysql","display_name":"MySQL","score":0.3240000009536743},{"id":"https://openalex.org/keywords/microsoft-access","display_name":"Microsoft Access","score":0.45899999141693115},{"id":"https://openalex.org/keywords/sql-92","display_name":"SQL-92","score":0.3330000042915344}],"concepts":[{"id":"https://openalex.org/C2778692605","wikidata":"https://www.wikidata.org/wiki/Q4041866","display_name":"Joins","level":2,"score":0.8983488082885742},{"id":"https://openalex.org/C135598885","wikidata":"https://www.wikidata.org/wiki/Q1366302","display_name":"Row","level":2,"score":0.6467613577842712},{"id":"https://openalex.org/C203763787","wikidata":"https://www.wikidata.org/wiki/Q371029","display_name":"Null (SQL)","level":2,"score":0.6059775948524475},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.5913617014884949},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.5767917633056641},{"id":"https://openalex.org/C2776760102","wikidata":"https://www.wikidata.org/wiki/Q5139990","display_name":"Code (set theory)","level":3,"score":0.43399131298065186},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.3183903694152832},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.2750259041786194},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.1332736611366272}],"mesh":[],"locations_count":2,"locations":[{"id":"mag:2254177225","doi":null,"is_oa":false,"landing_page_url":"http://dl.acm.org/citation.cfm?id=517448","pdf_url":null,"source":{"id":"https://openalex.org/S4306464808","display_name":"Addison-Wesley Longman Publishing Co., Inc. eBooks","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"ebook platform"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":"Addison-Wesley Longman Publishing Co., Inc. eBooks","raw_type":null},{"id":"mag:626676288","doi":null,"is_oa":false,"landing_page_url":"http://ci.nii.ac.jp/ncid/BA62340125","pdf_url":null,"source":null,"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":null}],"best_oa_location":null,"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":0,"referenced_works":[],"related_works":["https://openalex.org/W629246489","https://openalex.org/W2493855127","https://openalex.org/W78110690","https://openalex.org/W3001458894","https://openalex.org/W597614531","https://openalex.org/W7097963740","https://openalex.org/W2291213870","https://openalex.org/W3163031504","https://openalex.org/W2614192097"],"abstract_inverted_index":{"List":[0,3],"of":[1,4,19,109,321,455],"Tables.":[2],"Figures.":[5],"Acknowledgments.":[6],"1.":[7],"Introduction.":[8],"In":[9,64,140,213,279,380,485,526,595,641],"This":[10,13,26,65,141,214,280,381,486,527,596,642],"Chapter.":[11,66,142,215,281,382,487],"Why":[12,143,406],"Book?":[14],"Use,":[15],"Not":[16],"Feature.":[17],"Lots":[18],"Examples.":[20,58],"Multiple":[21,34,173],"Systems.":[22],"Legacy.":[23],"Tuning.":[24],"Who":[25],"Book":[27],"Is":[28],"For.":[29],"Contents.":[30],"Chapters.":[31],"Appendices.":[32],"Speaking":[33],"SQLs.":[35],"SQL":[36,38,289,402,481,509,543,648],"Engines.":[37],"Dialects.":[39],"Following":[40],"Conventions.":[41,403],"Text.":[42],"Code.":[43],"Understanding":[44,393,523],"the":[45,57,154,217,258,308,330,400,423,524,532,548],"MSDPN":[46],"Database.":[47,582],"Table":[48,408],"Details.":[49],"Customer.":[50],"Supplier.":[51],"Product.":[52],"Ordermaster.":[53],"Orderdetail.":[54],"Employee.":[55],"Using":[56,116,227,242,245,249,426,434,451,459,497,639],"Summary.":[59,136,209,275,376,476,520,588,636],"2.":[60],"Handling":[61],"Dirty":[62,67],"Data.":[63,68,519],"Case.":[69],"Sort":[70],"Order.":[71],"UPPER":[72,77,82],"and":[73,78,83,106,166,180,185,189,196,202,223,262,339,345,368,390,471,570,575,578,593,618,634],"LOWER":[74,79,84],"in":[75,80,111,366,422],"Searches.":[76],"UPDATE.":[81],"with":[85,101,123,219,416,438,441,447,457,510],"Dates.":[86,124,133,135],"INITCAP.":[87],"Space.":[88],"Removing":[89,514,573],"Spaces.":[90],"Additional":[91],"Features.":[92],"Size.":[93,95,97],"Actual":[94],"Defined":[96],"LIKE.":[98,107,442],"Quoting":[99],"Wildcards":[100],"ESCAPE.":[102],"LIKE":[103],"Variants.":[104],"Datatypes":[105,592],"Position":[108],"Expression":[110],"Expression.":[112],"How":[113,176],"LOCATE":[114,117],"Works.":[115,178],"Functions.":[118,160,174,435,501,594,606,608,610,612,623,625,627],"Sounds":[119],"Like.":[120],"BETWEEN.":[121,439],"Dealing":[122],"Converting":[125,449],"Dates":[126],"(and":[127],"Other":[128,622,658],"Datatypes).":[129],"Doing":[130,429],"Math":[131,430],"on":[132,397,431,632],"Finding":[134,153,307,359,436,453,505],"3.":[137],"Translating":[138,150],"Values.":[139,168,191,450],"Translate?":[144],"CASE/DECODE.":[145],"CASE.":[146],"DECODE.":[147],"CASE/DECODE":[148],"Variations.":[149],"NULL.":[151,181,445],"COALESCE/ISNULL/NVL.":[152],"First":[155],"Non-NULL:":[156],"COALESCE.":[157],"NULLIF.":[158],"Point":[159],"Getting":[161,169,395,502],"CASE":[162,170],"Effects":[163,171],"from":[164,172],"Functions":[165],"Column":[167,286],"UNION.":[175,468],"UNION":[177,179,182],"Problems?":[183],"Joins":[184,188],"Outer":[186,192,243,263],"Joins.":[187,193,237,244,264],"NULL":[190],"Subqueries.":[194,200,204,248,351],"Subqueries":[195],"Displays.":[197],"Embedded":[198],"Correlated":[199,201],"Non-Correlated":[203],"Another":[205],"Conditional":[206,611],"Expression:":[207],"TRANSLATE.":[208],"4.":[210],"Managing":[211],"Multiples.":[212],"What's":[216],"Issue":[218],"Multiples?":[220],"Duplicates.":[221,231,233],"Duplicates":[222],"a":[224,255,407,417,432],"Holding":[225],"Table.":[226,425],"ROWID":[228],"to":[229,371,444],"Remove":[230,581],"Near":[232],"Self":[234],"Join.":[235],"Unequal":[236],"SIMILAR.":[238],"Locating":[239,257],"Disconnected":[240],"Rows.":[241],"NOT":[246],"IN":[247],"MINUS.":[250],"Counting":[251],"Items.":[252],"Grouping":[253],"by":[254],"Subset.":[256],"Critical":[259],"Element.":[260],"Groups":[261],"Figuring":[265],"Distribution.":[266],"Checking":[267,399],"Detail":[268],"against":[269],"Master.":[270],"Two":[271],"Products":[272],"Together?":[273],"HAVING.":[274,346,369],"5.":[276],"Navigating":[277],"Numbers.":[278,325,327,331],"Auto-Numbering.":[282],"ASA:":[283],"Default.":[284],"Transact-SQL:":[285],"Property.":[287],"Microsoft":[288,542,647],"Server:":[290],"IDENTITY":[291],"(start,":[292],"increment).":[293],"Sybase":[294,538],"Adaptive":[295,535,539],"Server":[296,536,540],"Enterprise:":[297],"IDENTITY.":[298],"Oracle:":[299],"CREATE":[300,533],"SEQUENCE.":[301],"Informix:":[302],"SERIAL":[303],"Datatype.":[304],"Associated":[305],"Issues.":[306],"High":[309],"Value.":[310],"GROUP":[311],"BY,":[312],"COUNT,":[313],"HAVING":[314,470],"MAX":[315],"(COUNT).":[316],"FROM":[317,586],"Subquery.":[318,348],"Row":[319,324,337,343,616,619],"Counts":[320],"Various":[322],"Sorts.":[323],"System":[326,490,493,498,500,626],"You":[328],"Make":[329],"Top":[332],"N:":[333],"Six":[334],"Approaches.":[335],"1:":[336],"Limits":[338],"ORDER":[340],"BY.":[341],"2:":[342],"Numbers":[344],"3:":[347],"4:":[349],"Nested":[350],"5:":[352],"Aggregates":[353],"&":[354],"Many":[355],"Copies.":[356],"6:":[357],"Cursors.":[358],"Every":[360],"Nth.":[361],"What":[362],"Modulo":[363,365],"Is.":[364],"WHERE":[367,404],"Back":[370],"Nth":[372],"Row.":[373],"Running":[374],"Total.":[375],"6.":[377],"Tuning":[378,624],"Queries.":[379],"Perform,":[383],"#%&#@!":[384],"The":[385,388],"Basic":[386],"Problem.":[387],"Optimizer":[389],"Tools":[391],"for":[392],"It.":[394],"Information":[396],"Indexes.":[398,428,461,463,475],"Optimizer.":[401],"Clause.":[405],"Scan?":[409],"Data":[410,574],"Distribution":[411],"Statistics.":[412],"Disabling":[413],"an":[414],"Index":[415],"Bad":[418],"WHERE.":[419,469,472],"Comparing":[420,443,591],"Columns":[421],"Same":[424],"Non-Selective":[427],"Column.":[433],"Ranges":[437],"Matching":[440],"Negating":[446],"NOT.":[448],"OR.":[452],"Sets":[454],"Values":[456],"IN.":[458],"Multi-Column":[460],"Covering":[462],"Joining":[464],"Columns.":[465],"Sorting.":[466],"DISTINCT.":[467],"Views.":[473],"Forcing":[474],"Asking":[477],"Performance":[478],"Questions.":[479],"USING":[480],"TO":[482],"WRITE":[483],"SQL.":[484,511],"Systematically":[488],"Speaking.":[489,599],"Catalogs.":[491,494,499],"Listing":[492],"Writing":[495,508],"Queries":[496],"Administrative":[503],"Information.":[504],"Today's":[506],"Date.":[507],"GRANTing":[512],"Permissions.":[513],"Junk":[515],"Objects.":[516],"Creating":[517],"Test":[518],"Appendix":[521,589,637],"A.":[522],"Sample.":[525],"Appendix.":[528,597,643],"MegaSysDataProNet":[529],"Co.":[530],"Collecting":[531],"Scripts.":[534,550],"Anywhere.":[537],"Enterprise.":[541],"Server.":[544,649],"Oracle.":[545,651],"Informix.":[546,646],"Explaining":[547],"INSERT":[549,551,554,557,560,563,566],"INTO":[552,555,558,561,564,567],"customer.":[553],"supplier.":[556],"product.":[559],"employee.":[562],"ordermaster.":[565],"orderdetail.":[568],"Experimenting":[569],"Transaction":[571],"Management.":[572],"Objects:":[576],"DROP":[577,583],"DELETE":[579,585],"Commands.":[580,584],"Command.":[587],"B.":[590],"Comparatively":[598],"Datatype":[600],"Comparison.":[601,603,630],"Function":[602],"Character":[604],"(String)":[605],"Number":[607,614,617],"Date":[609],"Sequential":[613],"Methods.":[615,621],"ID":[620],"Join":[628],"Syntax":[629],"Notes":[631],"Environment":[633],"Display.":[635],"C.":[638],"Resources.":[640],"Books.":[644],"General.":[645],"mSQL/MySQL.":[650],"Sybase.":[652],"Transact-SQL.":[653],"Web":[654],"Sites.":[655],"Database":[656],"Vendors.":[657],"Offerings.":[659],"Newsgroups.":[660],"Index.":[661],"0201616386T04062001":[662]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W626676288","counts_by_year":[],"updated_date":"2026-11-14T11:04:58.165337","created_date":"2016-06-24T00:00:00"}
