The query given below will give an error. Which one of the following has to be replaced to get the desired output?SELECT ID, name FROM 1_Order WHERE instructor=1;

The SELECT statement in SQL Server is used to retrieve data from a database.  It can also be used to: Filter data Analyze data Assign values to local variables Create a new table from a SELECT query result  Here are some examples of SELECT statements: SELECT column1, column2 FROM table1, table2 WHERE column2='value' In this statement, the SELECT clause specifies one or more columns to retrieve. To specify multiple columns, use a comma and a space between column names. SELECT AS/SELECT INTO This method creates a new table from the existing one based on the SELECT query result... Show more

The SELECT statement in SQL Server is used to retrieve data from a database. 
It can also be used to:
Filter data
Analyze data
Assign values to local variables
Create a new table from a SELECT query result 

Here are some examples of SELECT statements:
SELECT column1, column2 FROM table1, table2 WHERE column2='value'

In this statement, the SELECT clause specifies one or more columns to retrieve.

To specify multiple columns, use a comma and a space between column names.
SELECT AS/SELECT INTO
This method creates a new table from the existing one based on the SELECT query result set. 

Topics include: Windowing, ranking, subqueries, data modification and constraints.

Related: SQL Server Practice Test: SQL Fundamentals

Show less