What is the use of partition by in sql?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL PLSQL Interview Questions

Define join and name different types of joins?

0 Answers  


mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql

0 Answers  


How to read/write files from pl/sql?

0 Answers  


How to fetch alternate records from a table?

0 Answers  


What is diff between bulk collect and forall

3 Answers   Metric Stream,






Are pl sql variables case sensitive?

0 Answers  


A table has 150 records. How do you retrieve 100th row to 120th row from that table ?

21 Answers   IBM,


Is join an inner join?

0 Answers  


How to get second highest salary from a table

3 Answers  


ename empno deptno amar 1 10 akbar 2 20 anthonny 3 30 jonathan 4 40 write a procedure to dispaly the column values ina row separated by a deleimiter eg - input - select ename from emp '|' output - amar|akbar|anthony|jonathan input - select empno from emp '@' o/p - 1@2@3@4 input - select deptno from emp '/' o/p - 10/20/30/40 Pls answer this questn.

2 Answers  


What trigger means?

0 Answers  


Can we use the cursor's to create the collection in PL/SQL?

0 Answers   MCN Solutions,


Categories