Home
Recent Q&A
Java
Cloud
JavaScript
Python
SQL
PHP
HTML
C++
Data Science
DBMS
Devops
Hadoop
Machine Learning
Azure
Blockchain
Devops
Ask a Question
What would be the output of below SQL statement, select empName from Employee order by 2 desc:
Home
Oracle
What would be the output of below SQL statement, select empName from Employee order by 2 desc:
0
votes
asked
Mar 18, 2023
in
Oracle
by
GeorgeBell
What would be the output of below SQL statement, select empName from Employee order by 2 desc:
a. Displays empName is ascending order
b. Produce an error
c. Displays empName is descending order
d. Displays 0 records
oracle-interview-questions-answers
Please
log in
or
register
to answer this question.
1
Answer
0
votes
answered
Mar 18, 2023
by
GeorgeBell
What would be the output of below SQL statement, select empName from Employee order by 2 desc:
correct answer:- Produce an error
Related questions
0
votes
Q: ________ database link of PL/SQL subprograms in the schema can use this link to access database objects in the corresponding remote database.
asked
Mar 18, 2023
in
Oracle
by
GeorgeBell
oracle-interview-questions-answers
0
votes
Q: What is the usage of Merge Statement?
asked
Jan 17
in
Oracle
by
AdilsonLima
oracle-interview-questions-answers
0
votes
Q: If we have not specified ASC or DESC after a SQL ORDER BY clause, the following is used by default
asked
Nov 6, 2021
in
Sql
by
rajeshsharma
sql-order-by
0
votes
Q: How do we display rows from the table without duplicates?
asked
Jan 17
in
Oracle
by
AdilsonLima
oracle-interview-questions-answers
0
votes
Q: Can we store pictures in the database and if so, how it can be done?
asked
Jan 19
in
Oracle
by
AdilsonLima
oracle-interview-questions-answers
0
votes
Q: What is the maximum number of triggers that can be applied to a single table?
asked
Jan 19
in
Oracle
by
AdilsonLima
oracle-interview-questions-answers
0
votes
Q: What is the parameter mode that can be passed to a procedure?
asked
Jan 19
in
Oracle
by
AdilsonLima
oracle-interview-questions-answers
0
votes
Q: Find the temperature in increasing order of all cities (a) SELECT city FROM weather ORDER BY temperature;
asked
Nov 25, 2021
in
Oracle
by
DavidAnderson
oracle
0
votes
Q: What are the various constraints used in Oracle?
asked
Jan 19
in
Oracle
by
AdilsonLima
oracle-interview-questions-answers
0
votes
Q: What is hash cluster in Oracle?
asked
Jan 19
in
Oracle
by
AdilsonLima
oracle-interview-questions-answers
...