Have any questions?
[email protected]
English
Vietnamese
French
Spanish
Korean
Japanese
Thai
Chinese
Indonesian
Login
Signup
Contact
Login
Home
Which clause would you use in a SELECT statement to limit the display to those employees whose salary is greater than 5000?
Question 1:
Which clause would you use in a SELECT statement to limit the display to those employees whose salary is greater than 5000?
A.
WHERE SALARY > 5000
B.
GROUP BY SALARY > 5000
C.
HAVING SALARY > 5000
D.
ORDER BY SALARY > 5000
These questions are from this test. Would you like to take a practice test?
PL/SQL Quiz 5 | Englishfreetest.com
20 minutes
10 questions
Do test
Some questions from the same exam
Which of the following is not true about the exception handling section of a PL/SQL block?
Which of the following is true about data types in PL/SQL?
Which of the following is not true about PL/SQL records?
The DROP TABLE statement
Can you commit inside a Trigger?
The command to remove rows from a table 'CUSTOMER' is:
Maximum characters allowed in dbms_out.put_line()
Which SQL statement is used to insert new data in a database?
Which clause would you use in a SELECT statement to limit the display to those employees whose salary is greater than 5000?
The command to remove rows from a table 'CUSTOMER' is:
Some other questions you may be interested in
"I am sorry, Tina, I will have to call you later today. I am working on fixing the software in use and I am in the ........ I*^*will give you my full attention as soon as I am done with this segment," Link said.
"Hi Zack. During the presentation, I want you to make sure to ask each representative, in ......., if he or she have any*^*questions. Is that clear?" Marcie asked.*^*
He bluntly alluded to the fact that he was quitting � in so many ........ He called the boss every unprintable name he*^*could think of and then told the boss of his low opinion of the company.
"What do I think about immigration? Well, I am in two ....... about should be done about immigration. I recognize that*^*our country offers freedom that others don't have and I don't think it is unreasonable to try to attain freedom.*^*However, if everyone was allowed to become a citizen, our infrastructure would likely fail," Velma told Eunice.
"I am not surprised that you want to join the Army. Soldiering is in your ........ Your dad, your grandfather, your greatgrandfather*^*and your great-great-grandfather were all soldiers," Bill told his nephew.
"Wow, John. I am really surprised at how talented you are in the construction field. You seem to really be in your .......*^*around power tools, wood and concrete." Chris said.