SQL STUDIO ERROR: i have an invalid column error at \'rownumber<=75\' SELECT v.e

Question

SQL STUDIO ERROR: i have an invalid column error at 'rownumber<=75'

SELECT

v.eolt_scenario_id,
v.scenario_value,
v.scenario_value_ecu,
v.scenario_value_name,
o.eolt_sequence_id,
o.scenario,
o.scenario_code,
o.scenario_column,
o.scenario_end,
o.scenario_option,
o.scenario_result,
o.scenario_start,
o.scenario_sub_name,
q.eolt_process_id,
q.[sequence],
q.sequence_end,
q.sequence_result,
q.sequence_start,
p.eolt_stage_id,
p.process,
p.process_result,
g.body_number,
g.eim_code,
g.model,
g.production_date,
g.production_shift_id,
g.sequence_number,
g.ship_destination,
g.stage_duration,
g.stage_end,
g.stage_name,
g.stage_result,
g.stage_start,
g.vin,
ROW_NUMBER()over(order by g.stage_start ) as rownumber
FROM  
    [EOLTData].[dbo].eolt_scenario_value v (NOLOCK)
    JOIN [EOLTData].[dbo].eolt_scenario o (NOLOCK) ON o.id = v.eolt_scenario_id
    JOIN [EOLTData].[dbo].eolt_sequence q (NOLOCK) ON q.id = o.eolt_sequence_id
    JOIN [EOLTData].[dbo].eolt_process p (NOLOCK) ON p.id = q.eolt_process_id
    JOIN [EOLTData].[dbo].eolt_stage g (NOLOCK) ON g.id = p.eolt_stage_id         
WHERE
rownumber <= 75  

ORDER BY
    g.stage_start;

Explanation / Answer

try it as

SELECT *

from (select v.eolt_scenario_id,

v.scenario_value,
v.scenario_value_ecu,
v.scenario_value_name,
o.eolt_sequence_id,
o.scenario,
o.scenario_code,
o.scenario_column,
o.scenario_end,
o.scenario_option,
o.scenario_result,
o.scenario_start,
o.scenario_sub_name,
q.eolt_process_id,
q.[sequence],
q.sequence_end,
q.sequence_result,
q.sequence_start,
p.eolt_stage_id,
p.process,
p.process_result,
g.body_number,
g.eim_code,
g.model,
g.production_date,
g.production_shift_id,
g.sequence_number,
g.ship_destination,
g.stage_duration,
g.stage_end,
g.stage_name,
g.stage_result,
g.stage_start,
g.vin,
ROW_NUMBER()over(order by g.stage_start ) as rownumber
FROM  
    [EOLTData].[dbo].eolt_scenario_value v (NOLOCK)
    JOIN [EOLTData].[dbo].eolt_scenario o (NOLOCK) ON o.id = v.eolt_scenario_id
    JOIN [EOLTData].[dbo].eolt_sequence q (NOLOCK) ON q.id = o.eolt_sequence_id
    JOIN [EOLTData].[dbo].eolt_process p (NOLOCK) ON p.id = q.eolt_process_id
    JOIN [EOLTData].[dbo].eolt_stage g (NOLOCK) ON g.id = p.eolt_stage_id )   
WHERE (rownumber <= 75 ) ORDER BY g.stage_start;

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.