[redaktim i pashqyrtuar][redaktim i pashqyrtuar]
Content deleted Content added
v Faqe e re: '''Select''' është një komandë në SQL. SELECT paraqet rezulltatin e rekordit prej një ose më shumë tabela. Ajo rinxjerr asnjë, një ose më shumë rreshta nga një ose më ...
 
No edit summary
Rreshti 7:
* <code>[[Having (SQL)|HAVING]]</code>
* <code>[[Order by (SQL)|ORDER BY]]</code>
 
==Shembuj==
{| class="wikitable" style="float: right; clear:right; margin: 1em" border="1"
!Table "T"
!Query
!Result
|-
|align="center"|
{| cellpadding="2" rules="all" style="border: 1px solid gray; text-align: center;"
! C1 !! C2
|-
| 1 || a
|-
| 2 || b
|}
||<code>SELECT * FROM T;</code>
|align="center"|
{| cellpadding="2" rules="all" style="border: 1px solid gray; text-align: center;"
! C1 !! C2
|-
| 1 || a
|-
| 2 || b
|}
|-
|align="center"|
{| cellpadding="2" rules="all" style="border: 1px solid gray; text-align: center;"
! C1 !! C2
|-
| 1 || a
|-
| 2 || b
|}
||<code>SELECT C1 FROM T;</code>
|align="center"|
{| cellpadding="2" rules="all" style="border: 1px solid gray; text-align: center;"
! C1
|-
| 1
|-
| 2
|}
|-
|align="center"|
{| cellpadding="2" rules="all" style="border: 1px solid gray; text-align: center;"
! C1 !! C2
|-
| 1 || a
|-
| 2 || b
|}
||<code>SELECT * FROM T WHERE C1 = 1;</code>
|align="center"|
{| cellpadding="2" rules="all" style="border: 1px solid gray; text-align: center;"
! C1 !! C2
|-
| 1 || a
|}
|-
|align="center"|
{| cellpadding="2" rules="all" style="border: 1px solid gray; text-align: center;"
! C1 !! C2
|-
| 1 || a
|-
| 2 || b
|}
||<code>SELECT * FROM T ORDER BY C1 DESC;</code>
|align="center"|
{| cellpadding="2" rules="all" style="border: 1px solid gray; text-align: center;"
! C1 !! C2
|-
| 2 || b
|-
| 1 || a
|}
|}