How do you set the order by command?

Question

I typed the following command in the oracle;

select * from emp where ndep in(10,30);

and had it as a result;

he’s all right, the problem is I wanted to put him in the descending order of the department number;

these were my attempts;

first attempt;

select * from emp where ndep in(10,30) | order by ndep desc;

attempt number two

select * from emp where ndep in(10,30)  order by ndep desc;

attempt 3

select * from emp where ndep in(10,30) and  order by ndep desc;

I was unsuccessful.

How do I hit the remote?

///////////////////////updating the post

select * from emp
where ndep in(10,30) 
and  
order by ndep desc;

that was the error message;

ORA-00936: expression not found 00936. 00000 - "Missing Expression" *Cause:
*Action: Line error: 3 Column: 5

Answer 1

Takes the and

Stay like this:

select * from emp
where ndep in(10,30) 
order by ndep desc;

Fiddle with SQL running here.