SQL Query


Q1. SELECT TOP 1 salary
FROM (SELECT DISTINCT TOP 6 salary FROM employee
ORDER BY salary DESC) a
ORDER BY salary



what does this ' a ' means here. \t\t



Q2. How to auto number the rows in a table in Oracle SQL*9



Q3. How to execute the query to find the 3rd highest salary of a employee query in Oracle SQL*9



Q3. Write a sql query to display employee name with grade name as a column. If a employee having salary greater than or equal to 5000 than the grade = GOLD otherwise SILVER

Hint : Employee(empid,empname,salary) Table

[IMG]file:///C:/Users/DELL/Desktop/image.png[/IMG]
Posted On: Monday 31st of December 2012 01:50:33 AM Total Views:  186
View Complete with Replies