Why plvtab is considered as the easiest way to access the pl/sql table?
No Answer is Posted For this Question
Be the First to Post Answer
what is the functionality of the function htmlentities? : Sql dba
how to check the 3rd max salary from an employee table? One of the queries used is as follows: select sal from emp a where 3=(select count(distinct(sal)) from emp b where a.sal<=b.sal). Here in the sub query "select count(distinct(sal)) from emp b where a.sal<=b.sal" or "select count(distinct(sal)) from emp b where a.sal=b.sal" should reveal the same number of rows is in't it? Can any one here please explain me how is this query working perfectly. However, there is another query to get the 3rd highest of salaries of employees that logic I can understand. Pls find the query below. "select min(salary) from emp where salary in(select distinct top 3 salary from emp order by salary desc)" Please explain me how "select sal from emp a where 3=(select count(distinct(sal)) from emp b where a.sal<=b.sal)" works source:http://www.allinterview.com/showanswers/33264.html. Thanks in advance Regards, Karthik.
Can I create table without primary key?
Two Methods of retrieving SQL?
7 Answers Atiric Software, Microsoft, Oracle, TCS, Wipro,
what does the t-sql command ident_current does? : Transact sql
How to display the records between two range in Oracle SQL Plus?
what is a constraint? : Sql dba
What is a recursive stored procedure?
Which is better varchar or nvarchar?
What are the types of variables use in pl sql?
i have xml source. xml source having lacks of records. i want extract/retrive xml source data using sql query. please tell me how to write query.
Is pl sql still used?