We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
- Prepare
- SQL
- Basic Select
- Select All
- Discussions
Select All
Select All
Sort by
recency
|
379 Discussions
|
Please Login in order to post a comment
SELECT * FROM CITY;
My Solution:
myself also faced error for this basic query, plz write your query after comment section.don't write your query at first line to avoid error.
So I submitted SELECT * FROM CITY, and instead I got this:
SQL30082N Security processing failed with reason "1" ("PASSWORD EXPIRED"). SQLSTATE=08001 DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned: SQL1024N A database connection does not exist. SQLSTATE=08003 SQL1024N A database connection does not exist. SQLSTATE=08003
Anyone know why? Thanks in advance.
SELECT * FROM CITY; use semicolon
if you wrote your query at first line, then plz write the query after the comment section to avoid error.
SELECT ID, NAME, COUNTRYCODE, DISTRICT, POPULATION FROM CITY; OR SELECT * FROM CITY; This symbol '*' represents all columns :))