Jump to content

Select (SQL): Revision history


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

(newest | oldest) View (newer 50 | ) (20 | 50 | 100 | 250 | 500)

12 June 2024

  • curprev 00:5200:52, 12 June 2024CGP05 talk contribsm 34,184 bytes +1,157 Reverted edits by 49.237.41.22 (talk) (AV) undo Tags: AntiVandal Rollback
  • curprev 00:5200:52, 12 June 202449.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 202449.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

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

19 August 2020

28 July 2020

11 June 2020

27 May 2020

11 May 2020

8 May 2020

7 May 2020

(newest | oldest) View (newer 50 | ) (20 | 50 | 100 | 250 | 500)