Select ID, name, dept name, salary * 1.1 where instructor;The query given below will not give an error. Which one of the following has to be replaced to get the desired output?

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