Select (SQL): Revision history

20 March 2024

• curprev 19:3019:30, 20 March 2024‎ Fjerdingen talk contribs‎ m 34,184 bytes +20‎ Some minor adjustments, mostly towards ISO SQL terminology. undo

5 January 2024

• curprev 13:4613:46, 5 January 2024‎ Сале talk contribs‎ 34,164 bytes +57‎ →‎Non-standard syntax: Can't add reference to: https://mariadb.com/kb/en/select-offset-fetch/ undo

19 October 2023

• curprev 03:2203:22, 19 October 2023‎ HeyElliott talk contribs‎ 34,107 bytes +1‎ WP:N'T undo Tag: 2017 wikitext editor

24 August 2023

• curprev 13:3613:36, 24 August 2023‎ Citation bot talk contribs‎ 34,106 bytes +38‎ Add: date. | Use this bot. Report bugs. | Suggested by Abductive | #UCB_webform 1141/3850 undo

6 August 2023

• curprev 14:0414:04, 6 August 2023‎ 186.177.189.98 talk‎ 34,068 bytes +158‎ →‎Method with positioning undo
• curprev 14:0014:00, 6 August 2023‎ 186.177.189.98 talk‎ 33,910 bytes +151‎ →‎Other simple method (a little more efficient than read all rows) undo

8 March 2023

• curprev 20:2420:24, 8 March 2023‎ Raydann talk contribs‎ m 33,759 bytes +89‎ Reverted edits by 2A02:C7C:8A39:D300:7A6C:84FF:FEC6:F92D (talk) (AV) undo Tag: Rollback
• curprev 20:2420:24, 8 March 2023‎ 2a02:c7c:8a39:d300:7a6c:84ff:fec6:f92d talk‎ 33,670 bytes −89‎ No edit summary undo Tags: Reverted Mobile edit Mobile web edit

2 February 2023

• curprev 12:4412:44, 2 February 2023‎ 185.3.46.212 talk‎ 33,759 bytes +20‎ No edit summary undo

14 June 2022

• curprev 21:5321:53, 14 June 2022‎ Jarble talk contribs‎ m 33,739 bytes +22‎ linking undo

20 March 2022

• curprev 21:2021:20, 20 March 2022‎ Vt320 talk contribs‎ 33,717 bytes −8‎ use new article name for Db2 undo

15 December 2021

• curprev 01:3301:33, 15 December 2021‎ Cedar101 talk contribs‎ m 33,725 bytes +33‎ →‎Hierarchical query: {{sxhl}} undo

14 December 2021

• curprev 14:2914:29, 14 December 2021‎ Mindmatrix talk contribs‎ 33,692 bytes −237‎ revert - rm promotional link disguised as a ref undo Tag: Manual revert
• curprev 08:5808:58, 14 December 2021‎ 202.69.11.226 talk‎ 33,929 bytes +237‎ No edit summary undo Tag: Reverted

15 October 2021

• curprev 17:0017:00, 15 October 2021‎ ClueBot NG talk contribs‎ m 33,692 bytes −29‎ Reverting possible vandalism by 2.154.38.18 to version by Cedar101. Report False Positive? Thanks, ClueBot NG. (4058610) (Bot) undo Tag: Rollback
• curprev 17:0017:00, 15 October 2021‎ 2.154.38.18 talk‎ 33,721 bytes +29‎ →‎Rows Pagination undo Tag: Reverted

1 October 2021

• curprev 15:3015:30, 1 October 2021‎ Cedar101 talk contribs‎ m 33,692 bytes +2‎ →‎Generating data in T-SQL: lang="tsql" undo
• curprev 15:2915:29, 1 October 2021‎ Cedar101 talk contribs‎ m 33,690 bytes +28‎ →‎Query evaluation ANSI: lang="postgresql" undo
• curprev 15:2715:27, 1 October 2021‎ Cedar101 talk contribs‎ m 33,662 bytes +18‎ →‎Method with filter (it is more sophisticated but necessary for very big dataset): lang="postgresql" undo
• curprev 15:2615:26, 1 October 2021‎ Cedar101 talk contribs‎ m 33,644 bytes +6‎ →‎Other simple method (a little more efficient than read all rows): lang="postgresql" undo

29 June 2021

• curprev 22:0422:04, 29 June 2021‎ Philoserf talk contribs‎ 33,638 bytes +97‎ Importing Wikidata short description: "SQL statement that returns a result set of records from one or more tables" (Shortdesc helper) undo

15 May 2021

• curprev 13:0813:08, 15 May 2021‎ Jarble talk contribs‎ m 33,541 bytes +4‎ link relational operator using Find link undo

23 March 2021

• curprev 04:0204:02, 23 March 2021‎ Enervation talk contribs‎ m 33,537 bytes −9‎ →‎Limiting result rows undo Tag: Visual edit

4 March 2021

• curprev 22:3522:35, 4 March 2021‎ Fjerdingen talk contribs‎ 33,546 bytes −223‎ →‎Overview: remove the "syntactic sugar" part. DISTINCT makes full sense, (As in many cases you can achieve the same result in many ways. Here using UNION, GROUP BY and others.) undo
• curprev 22:2722:27, 4 March 2021‎ Fjerdingen talk contribs‎ 33,769 bytes +13‎ →‎Method with filter (it is more sophisticated but necessary for very big dataset): Add Mimer SQL to list undo
• curprev 22:2622:26, 4 March 2021‎ Fjerdingen talk contribs‎ 33,756 bytes +13‎ →‎Method with positioning: Add Mimer SQL as supporting OFFSET clause undo
• curprev 22:2522:25, 4 March 2021‎ Fjerdingen talk contribs‎ 33,743 bytes +13‎ →‎Other simple method (a little more efficient than read all rows): Add Mimer SQL to the list of supporting FETCH FIRST syntax undo
• curprev 22:1222:12, 4 March 2021‎ Fjerdingen talk contribs‎ 33,730 bytes −33‎ →‎Inline view: derived table is the ANSI/ISO SQL standard term (Feature F591, Derived tables). Inline view is a vendor specific term. undo

5 January 2021

• curprev 09:0309:03, 5 January 2021‎ Mx. Granger talk contribs‎ 33,763 bytes −40‎ removing undefined reference undo

23 December 2020

• curprev 07:4207:42, 23 December 2020‎ Monkbot talk contribs‎ m 33,803 bytes −30‎ Task 18 (cosmetic): eval 6 templates: del empty params (3×); hyphenate params (3×); undo Tag: AWB

27 November 2020

• curprev 14:0914:09, 27 November 2020‎ WOSlinker talk contribs‎ 33,833 bytes +108‎ change source to syntaxhighlight undo

25 November 2020

• curprev 21:5021:50, 25 November 2020‎ Federico Razzoli talk contribs‎ 33,725 bytes +289‎ Mention the relational operations that match some of the SELECT clauses undo
• curprev 21:3621:36, 25 November 2020‎ Federico Razzoli talk contribs‎ 33,436 bytes +124‎ Add SELECT clause, better wording for AS (it doesn't "temporarily rename" columns), move AS after SELECT clause undo
• curprev 21:1821:18, 25 November 2020‎ Federico Razzoli talk contribs‎ 33,312 bytes +223‎ →‎Overview: mention that DISTINCT is a type of GROUP BY undo

23 September 2020

• curprev 05:4505:45, 23 September 2020‎ WikiCleanerBot talk contribs‎ m 33,089 bytes −6‎ v2.03b - Bot T19 CW#83 - WP:WCW project (Heading start with three "=" and later with level two) undo Tag: WPCleaner

18 September 2020

• curprev 14:5214:52, 18 September 2020‎ AnomieBOT talk contribs‎ 33,095 bytes +266‎ Rescuing orphaned refs ("ms-sql-select-into" from SQL syntax) undo
• curprev 08:0008:00, 18 September 2020‎ Jan Spousta talk contribs‎ 32,829 bytes +8,065‎ +material from an older version of SQL article undo Tag: 2017 wikitext editor

11 September 2020

• curprev 16:2316:23, 11 September 2020‎ Comp.arch talk contribs‎ m 24,764 bytes 0‎ No edit summary undo Tag: 2017 wikitext editor
• curprev 16:1116:11, 11 September 2020‎ Comp.arch talk contribs‎ m 24,764 bytes −4‎ Use e.g. lower case "select"? Depending for first letter? undo Tag: 2017 wikitext editor
• curprev 16:0616:06, 11 September 2020‎ Comp.arch talk contribs‎ m 24,768 bytes +5‎ No edit summary undo Tag: 2017 wikitext editor

19 August 2020

• curprev 16:3816:38, 19 August 2020‎ Black Walnut talk contribs‎ 24,763 bytes 0‎ →‎introduction: syntax (English, not SQL), reduced verbiage undo

28 July 2020

• curprev 10:2310:23, 28 July 2020‎ 217.92.93.239 talk‎ 24,763 bytes −3‎ No edit summary undo

11 June 2020

• curprev 19:1119:11, 11 June 2020‎ 84.254.88.106 talk‎ 24,766 bytes +1‎ fixed typo undo

27 May 2020

• curprev 22:2722:27, 27 May 2020‎ 216.45.223.34 talk‎ 24,765 bytes +3‎ No edit summary undo Tags: Mobile edit Mobile web edit

11 May 2020

• curprev 18:3018:30, 11 May 2020‎ DannyS712 bot talk contribs‎ m 24,762 bytes +828‎ Task 70: Update syntaxhighlight tags - remove use of deprecated <source> tags undo Tag: AWB

8 May 2020

• curprev 06:4406:44, 8 May 2020‎ Cedar101 talk contribs‎ m 23,934 bytes +260‎ →‎Rows Pagination: <code> undo

7 May 2020

• curprev 11:2211:22, 7 May 2020‎ Cedar101 talk contribs‎ m 23,674 bytes +7‎ →‎Method with positioning: lang="postgres" undo
• curprev 11:2111:21, 7 May 2020‎ Cedar101 talk contribs‎ m 23,667 bytes +113‎ →‎Non-standard syntax: highlight="2" undo
• curprev 11:1511:15, 7 May 2020‎ Cedar101 talk contribs‎ m 23,554 bytes +49‎ →‎FETCH FIRST clause: <source lang="sql" highlight="2"> undo
• curprev 11:1211:12, 7 May 2020‎ Cedar101 talk contribs‎ m 23,505 bytes −4‎ →‎Other simple method (a little more efficient than read all rows) undo