Select Query
- What will be the output of a query given below?
SELECT Employee_id, FirstName, LastName
FROM Employee
WHERE Employee_id=1;
-
View Hint View Answer Discuss in Forum
NA
Correct Option: C
Clause “WHERE” is also used, which tell the compiler to show only that rows which are belong to Employee_id=1.
- What will be the output of a query given below?
SELECT * FROM Employee
WHERE Employee_id=1;
-
View Hint View Answer Discuss in Forum
NA
Correct Option: C
Clause “WHERE” is also used, which tell the compiler to show only that rows which belong to Employee_id=1.
- Find the error?
SELECT *;
-
View Hint View Answer Discuss in Forum
NA
Correct Option: A
“SELECT” clause cannot be used without clause “FROM”.
- Can “SELECT” clause be used without the clause “FROM”?
-
View Hint View Answer Discuss in Forum
NA
Correct Option: C
“SELECT” clause is used to show rows and columns of a particular table and clause “from” is used to denote a table name.
- What will be the output of a query given below?
SELECT Employee_id, FirstName, LastName
FROM person;
-
View Hint View Answer Discuss in Forum
NA
Correct Option: D
“SELECT” clause is used to show all rows and columns that are mention with the query.