[sowmya571]

hello



Identify the 4 coding errors in the above code



SELECT employee_id , last_name sal*12 ANNUAL SALARY FROM EMPLOYEES ;





SOLUTIOn



error 1: There shud e a comma after Last_name



error 2: AnnUAL SALARY SPACE SHUD IS REMOVED OR REPRESETED in



Annual_salary or " Annual Salary"

Error 3: sal shud e given as table field name



Error 4: * is bnot there X is there




BYE



SOWMYA




Edited by: sowmya571

[Natural]

Hii Friends,

I have a table Employee with the following fields....

Emp_Id

Emp_Name

Dept_Id

Sal.........etc.

Now I want a query to display the Employee Id, Employee Name & Salary Of middle five Employees based on Salary.....

I mean if table is displayed in ascending order of Salary, and there are 20 records in all..... then I need to display the 8th, 9th, 10th, 11th &12th record..... I hope it's clear by now......

I will post the answer query...... on fifth day from today.....