Select (SQL): Revision history

Filter revisionsshowhide

To date:

Tag filter:

Invert selection

External tools:

For any version listed below, click on its date to view it. For more help, see Help:Page history and Help:Edit summary. (cur) = difference from current version, (prev) = difference from preceding version, m = minor edit, → = section edit, ← = automatic edit summary

curprev 20:5920:59, 25 January 2025 Asilvering talk contribs m 34,219 bytes −32 Removing link(s) Wikipedia:Articles for deletion/Where (SQL) closed as delete (XFDcloser) undo

curprev 12:2912:29, 26 December 2024 Richard Yin talk contribs m 34,251 bytes −1 Reverted edits by Vaishnavi 7667 (talk): rv incorrect grammar (AV) undo Tags: AntiVandal Rollback
curprev 12:2812:28, 26 December 2024 Vaishnavi 7667 talk contribs 34,252 bytes +1 No edit summary undo Tag: Reverted

curprev 00:4800:48, 10 December 2024 Dwo talk contribs m 34,251 bytes −4 →Overview: -op pl undo

curprev 23:3823:38, 17 October 2024 Mindmatrix talk contribs m 34,255 bytes −9 Reverted edit by 219.88.227.163 (talk) to last version by AnomieBOT undo Tag: Rollback
curprev 22:5722:57, 17 October 2024 219.88.227.163 talk 34,264 bytes +9 No edit summary undo Tag: Reverted

curprev 21:0921:09, 3 October 2024 AnomieBOT talk contribs m 34,255 bytes +36 Dating maintenance tags: {{Excessive examples}} {{Trivia}} undo
curprev 19:0819:08, 3 October 2024 Anna328p talk contribs 34,219 bytes +35 add cleanup templates undo Tag: 2017 wikitext editor

curprev 00:5200:52, 12 June 2024 CGP05 talk contribs m 34,184 bytes +1,157 Reverted edits by 49.237.41.22 (talk) (AV) undo Tags: AntiVandal Rollback
curprev 00:5200:52, 12 June 2024 49.237.41.22 talk 33,027 bytes −482 →Query evaluation ANSI: g.GroupName, count(g.*) as NumberOfMembers from users u inner join groups g on g.Userid = u.Userid group by GroupName having count(g.*) > 5 </syntaxhighlight> |8= the SELECT list is evaluated and returned as Vtable 7 |9= the DISTINCT clause is evaluated; duplicate rows are removed and returned as Vtable 8 |10= the ORDER BY clause is evaluated, ordering the rows and returning VCursor9. This is a cursor and not a table because ANSI defines a cursor as an ordered set... undo Tags: Reverted Mobile edit Mobile web edit
curprev 00:5100:51, 12 June 2024 49.237.41.22 talk 33,509 bytes −675 more tables.<ref>{{cite web |url=http://msdn2.microsoft.com/en-us/library/ms189499.aspx |title=Transact-SQL Syntax Conventions |author=Microsoft |date=23 May 2023 }}</ref><ref>{{cite web |url=http://dev.mysql.com/doc/refman/5.0/en/select.html|title=SQL SELECT Syntax |author=MySQL}}</ref> A SELECT statement retrieves zero or more rows from one or more database tables or database views. In most applications, <code>SELECT</code> is th... undo Tags: Reverted references removed Mobile edit Mobile web edit

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

25 January 2025

26 December 2024

10 December 2024

17 October 2024

3 October 2024

12 June 2024

20 March 2024

5 January 2024

19 October 2023

24 August 2023

6 August 2023

8 March 2023

2 February 2023

14 June 2022

20 March 2022

15 December 2021

14 December 2021

15 October 2021

1 October 2021

29 June 2021

15 May 2021

23 March 2021

4 March 2021

5 January 2021

23 December 2020

27 November 2020

25 November 2020

23 September 2020

18 September 2020

11 September 2020