What are the 5 parts of a SELECT statement that are required to - ProProfs Discuss
Advertisement

What are the 5 parts of a SELECT statement that are required to execute successfully?

Asked by Castle, Last updated: Mar 27, 2024

+ Answer
Request
Question menu
Vote up Vote down

1 Answer

castle96

castle

castle96
Castle

Answered Apr 25, 2019

SELECT, FROM, column, semi-colon, table

At a minimum, these 5 parts MUST be present to execute a SQL select statement. There are some applications that may let the user eliminate the need for a semi-colon, but it is rare. Good practice is to use it to correctly define the end of a SQL statement
upvote downvote
Reply 

Advertisement
Advertisement
Search for Google images Google Image Icon
Select a recommended image
Upload from your computer Loader
Image Preview
Search for Google images Google Image Icon
Select a recommended image
Upload from your computer Loader
Image Preview
Search for Google images Google Image Icon
Select a recommended image
Upload from your computer Loader

Email Sent
We have sent an email to your address "" with instructions to reset your password.