Difference between revisions of "RIGHT/de"
From SQLZOO
< RIGHT
(Created page with "Category:Deutsch <table align='right' border='1'> <caption>Kompatibilität</caption> <tr><th colspan='3'>RIGHT(s,i)</th></tr> <tr><td align='center'>'''DBMS'''</td><td ali...") |
|||
| Line 15: | Line 15: | ||
<p></p> | <p></p> | ||
<pre style='width:60ex'> | <pre style='width:60ex'> | ||
| − | RIGHT(' | + | RIGHT('Hallo Welt', 4) -> 'Welt' |
</pre> | </pre> | ||
Latest revision as of 11:55, 28 October 2012
| RIGHT(s,i) | ||
|---|---|---|
| DBMS | OK | Alternative |
| Ingres | Ja | |
| MySQL | Ja | |
| Oracle | Nein | SUBSTR(s, -i) |
| PostgreSQL | Nein | SUBSTRING(s , 1+LENGTH(s)-i , i) |
| SQL Server | Ja | |
RIGHT
RIGHT(s,n) liefert n Zeichen aus der Zeichenkette s, beginnend vom Ende der Zeichenkette.
RIGHT('Hallo Welt', 4) -> 'Welt'
SELECT name, SUBSTRING(name, 1+LENGTH(name)-3, 3) FROM bbc
SELECT name, SUBSTR(name, -3) FROM bbc
SELECT name, RIGHT(name, 3) FROM bbc
Siehe auch
| Sprache: | English • Deutsch |
|---|
