Computer Science, asked by kmsakthivelkm, 7 months ago

The following query is producing an error. Identify the error and also write the correct query. SELECT * FROM EMP ORDER BY NAME WHERE SALARY>=5000;

Answers

Answered by eashanshetty19

You should check where as the answer

Explanation

Where selects the rows on a particular condition. From gives the relation which involves the operation. Since Instructor is a relation it has to have from clause.

Previous Question

Next Question

Similar questions

Physics, 3 months ago

Ch-motion A biker starts a race and crosses the half line in 3 second with speed 54 km/h and after that he increases his speed uniformally at a rate $\sf{7.5 m/s^2}$ and completed the race in 5 second. (A) Acceleration in the first half of the race is $\sf{ 5 m/s^2.}$ (B) He finished the race with speed 108 km/h. (C) Acceleration in the second half of the race is...

Math, 3 months ago

दशमलव के रूप में लिखिए a) 36/100...

Math, 3 months ago

Give possible expressions for speed and time, if the distance is given by the expression 12x^2 + 25x + 12....

English, 7 months ago

I found him such a well-informed person that...........

Science, 7 months ago

What do we call the substance broken down by electrolysis? * 1) Solvent 2) Solute 3) Substrate 4) Electrolyte ...

Science, 1 year ago

if the roots of a plant are growing towards nitrate concentration region of the soil it is. a) phototropism. b) hydrotropism. c)thigmotropism. d) chemotropism...

Science, 1 year ago

define acclimatisation and respond to stimulus...

Chemistry, 1 year ago

is it possible to change the temperature and pressure of a fixed mass of gas without changing its volume . Explain...

The following query is producing an error. Identify the error and also write the correct query. SELECT * FROM EMP ORDER BY NAME WHERE SALARY>=5000;​

Answers

The following query is producing an error. Identify the error and also write the correct query. SELECT * FROM EMP ORDER BY NAME WHERE SALARY>=5000;