Is pl sql different from sql?
What is set serveroutput on?
What are the operators in sql?
How do I run a query in pl sql developer?
Hi, Can anybody please explain me the flow of the below query. I am not able to understand how this query works. This query is for finding the Nth highest salary.. SELECT DISTINCT (a.sal) FROM EMP A WHERE &N = (SELECT COUNT (DISTINCT (b.sal)) FROM EMP B WHERE a.sal<=b.sal); If N = 2 then second highest salary will be the o/p. If N = 3 then third highest salary will be the o/p. and so on.. Thanks, Nitin
5 Answers Deloitte, Ness Technologies,
how can we know the number of days between two given dates using mysql? : Sql dba
define different types of trigger. : Sql dba
how to present a past time in hours, minutes and seconds? : Sql dba
Can we use join in subquery?
Why sql query is slow?
Two Methods of retrieving SQL?
7 Answers Atiric Software, Microsoft, Oracle, TCS, Wipro,
How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?
Define commit?