| Other SQL PLSQL Interview Questions |
|| Asked @
|i have a table t1 a math 20
b phy 30
a math 40
b phy 23
c che 21
c che 56
write a quire to find out the max markr of each subject
|Create a procedure to delete certain records from a table
and display the total number of records deleted in this
process. (Condition for deletion can be of ur choice, for
instance delete all records where eid='')
|What is the Query to print out the individual total number of
duplicate row in sql.
|i have a word
I require a o/p
Need to delete the middle stars.
|what eliminate duplicate without using roenum and not
|How the execution will be done in exceptions?
|can we call a procedure into another procedure?If yes means
how you can pass the perameters for the two procedures?
|How to get second highest salary from a table
|Difference between IN and EXISTS
|What is a constraint. Types of constraints ?
|In a package if we have 10 procedures or functions,How to
know which will execute first?
|What are the different types of joins and explain them
|For more SQL PLSQL Interview Questions Click Here |