Logo 
Search:

SQL FAQ

Submit Interview FAQ
Home » Interview FAQ » SQLRSS Feeds

Will below statements will work or not?

  Shared By: Shruti Sharma    Date: Dec 21    Category: SQL    Views: 977

Answer:

a.) Select *

The FROM clause is missing. The two mandatory components of a SELECT statement are the SELECT and FROM.


b.) Select * from checks

The semicolon, which identifies the end of a SQL statement, is missing.


c.) Select amount name payee FROM checks;

You need a comma between each column name: Select amount, name, payee FROM checks;

Share: 
 

Didn't find what you were looking for? Find more on Will below statements will work or not? Or get search suggestion and latest updates.


Your Comment
  • Comment should be atleast 30 Characters.
  • Please put code inside [Code] your code [/Code].


Tagged: