E-mail Print PDF

SELECT 

1
2
 
SELECT column_name(s)
FROM table_name

и

1
 
SELECT * FROM table_name

Note Note:

There is a table "Persons":

P_IdLastNameFirstNameAddressCity
1 Hansen Ola Timoteivn 10 Sandnes
2 Svendson Tove Borgvn 23 Sandnes
3 Pettersen Kari Storgt 20 Stavanger 

1
 
SELECT LastName,FirstName FROM Persons

Query Result:

LastNameFirstName
Hansen Ola
Svendson Tove
Pettersen Kari

SELECT *

1
 
SELECT * FROM Persons

Query Result:

P_IdLastNameFirstNameAddressCity
1 Hansen Ola Timoteivn 10 Sandnes
2 Svendson Tove Borgvn 23 Sandnes
3 Pettersen Kari Storgt 20 Stavanger

Comments

 
0 #1 Ололо 2010-10-15 21:25 Sheer garbage. Where the full command syntax?? Quote
 
 
-2 #2 Шелест Константин 2010-10-28 19:00 Ololo! What word you just do not understand? there are exactly! Quote
 
 
+6 #3 Трололо 2010-12-01 09:09 SELECT [DISTINCT | ALL] .{ * | [columnExpressi on [AS newName]] [ , …]}
FROM TableName [alias] [ , … ]
[WHERE condition]
[GROUP BY columnList] [HAVING condition]
[ORDER BY columnList]

ne? where faith, group buy, heving and order? o_O Quote
 
 
-8 #4 Сцуко 2010-12-16 20:43 Gnobi Shnelesta !)))) Quote
 
 
+3 #5 СцукоЁб 2011-01-10 14:25 All the beam, the rest of the syntax and so is understandable, because almost everywhere WHERE yuzaetsya. Quote
 
 
+1 #6 andiez 2011-12-23 13:26 Quote
 

Authorization

Nice Ajax Poll

Which one of my extensions is the best?

Statistics

Translate

русскийitalianoDeutschEnglishLATVIANукраїнськаfrançaispolski
1

Advertisement


тонировка стекол автомобиля

© 2009 ageent.ru.