|
|
-
Thanks Niladri. We updated the script....
|
-
Hi,
We cannot use "IDENTITY" for generating sequential numbers in Oracle as we do in Sql server. We have to do so by using Sequence.
Steps
a) First create a sequence
b) Create the table
c)Insert record into the table (created at step b) using sequence...
|
-
Or use the table alias as
select e.*,row_number()over(partition by department order by salary) as rid
from PLC2_Employees e...
|
-
Or use the table alias as
SELECT e.*,
DENSE_RANK()OVER (PARTITION BY department ORDER BY salary desc) Rnk
FROM PLC2_Employees e...
|
-
Hi , after I run ur query in Oracle 11g R2 Express Edition, I am getting the error
**ORA-00933: SQL command not properly ended**
Donot use the alias as A e.g.
Select ***
From (....) As A
....
Instead use
Select ***
...
|
-
The object name "#PLC2_Employees" is wrong . It should be PLC2_Employees...
|
-
The query
SELECT *,
DENSE_RANK()OVER (PARTITION BY department ORDER BY salary desc) Rnk
FROM PLC2_Employees
will throw error **ORA-00923: FROM keyword not found where expected**
Use the column names instead
SELECT Employee...
|
-
If I run your query , I am getting this error
**ORA-00923: FROM keyword not found where expected**
The reason is that "employeesal" is an invalid object here. It should be "PLC2_Employees" as specified in teh original question.
Second mistake,...
|
|
|
-
This challenge is about finding second highest salary for each department...
|