title: ORA-00942 table or view does not exist
body: <p>I have a sql query in db oracle
  I want to output max value.
  SQL query contains unique field values</p>
  
  <p>Sql query below contains duplicate rows:</p>
  
  <pre><code>select 
  field1,field2,field3,field4,field5,field6,field7,field8,field9,MAX(field10) as field10
  
  from(
  
  select 
  field1,field2,field3,field4,field5,field6,field7,field8,field9,field10
  
  from table
  
  )tabl
  
  GROUP BY field1,field2,field3,field4,field5,field6,field7,field8,field9
  </code></pre>
  
  <p>I corrected sql request but it doesn't work.<br>
  Sql query below an error message is displayed :ORA-00942 table or view does not exist.</p>
  
  <pre><code>select
  
  field1,field2,field3,field4,field5,field6,field7,field8,field9
  
  ,(SELECT MAX(field10)  FROM tabl ) as field10
  
  from(
  select 
  field1,field2,field3,field4,field5,field6,field7,field8,field9,field10
  
  from table
  )tabl
  </code></pre>
  
  <p>how can i fix it? 
  Thanks for your help!</p>