What does partition by mean in sql?
No Answer is Posted For this Question
Be the First to Post Answer
What is the difference between partition and index?
Write a sql query to get the third highest salary of an employee from employee_table?
1.when will you use week refcursor and when will you use strong ref cursor ? 2.what is the use of sql trace..how do you use it ? 3.can you please send all the sql plus commands...like set line 6000....
Is sql pronounced sequel or sql?
How do you display "13th of November, 17 days left for month end" without hardcoding the date.
Suppose There is a string A.B....C.......D.........E........F In this string dots (.) are not having fixed count in between of string. I want the output to have string with one dot between. I.e. A.B.C.D.E.F
How do you retrieve set of records from database server. {Set max records = 100 & use paging where pager page no or records = 10 & after displaying 100 records again connect to database retrieve next 100 }
What is the command used to fetch the first 5 characters of a string?
using cursors salesman get bonus as 10% of their salary , managers get 20% , analalist get 30%. generae a report showing the employee name, salary , bonus.
How can get second highest salary in sql?
suppose we have values like 1 5 7 in a colum.Now we want numbers like(2 3 4 6) that exists between 1 5 7.How can we do this using sql query??
What does subquery mean in sql?