how are rank and dense rank being alloted for column with same values over a particular column
Answer / shipra gupta
salary R DR
800 1 1
800 1 1
200 3 2
|Is This Answer Correct ?||0 Yes||0 No|
What is the difference between sql/pl-sql/embeded sql?
What is a 'instead of trigger'?
in sql table following column r there i want find 1st paid ,2nd paid,3rd paid date for same |service_type|date |vehicle_no| |------------|------|_---------| |paid |23 jan|MH12H2007 | | | | | |paid |26 feb|MH12H2007 | | | | | | | | | |paid |28 mar|MH12H2007 | i want o/p like below vehicle no| 1st paid date | 2nd paid date|3rd paid |latest paid date| pls help me out
A table was given with 3 columns like Manager id,Manager Name and Employee name. Question was to create hierarchy.
I am creating an index on Emp table Empno column,if u using this indexed column in ur SELECT stmt. where clause,then how do u know that yr index will be working or nor? Thanks Advance...
what is difference between "Primary key" and "Unique key"?
How will you make performance better for application including front end and back
What is the Subquery?
What are the steps you take to tune(performance tuning) the code in plsql?
If we update a complex view, is base table will get update ?
if we give update table_name set column_name= default. what will happen? its given in pl sql block.what will hapen?
if i perform any operation on views such as insert, delete etc will my base table get affected?????