|
Related Questions |
View Answer |
|
How will you delete duplicating rows from a base table?
|
View Answer
|
|
What is difference between SUBSTR and INSTR?
|
View Answer
|
|
There is a string 120000 12 0 .125 , how you will find the position of the decimal place?
|
View Answer
|
|
There is a % sign in one field of a column. What will be the query to find it?
|
View Answer
|
|
When do you use WHERE clause and when do you use HAVING clause?
|
View Answer
|
|
Which is more faster - IN or EXISTS?
|
View Answer
|
|
What is a OUTER JOIN?
|
View Answer
|
|
How you will avoid your query from using indexes?
|
View Answer
|
|
What is a pseudo column. Give some examples?
|
View Answer
|
|
Suppose a customer table is having different columns like customer no, payments.What will be the query to select top three max payments?
|
View Answer
|
|
Display the records between two range?
|
View Answer
|
|
Find out nth highest salary from emp table
|
View Answer
|
|
Display the number value in Words?
|
View Answer
|
|
Display Odd/ Even number of records
|
View Answer
|
|
How do you find the number of rows in a Table ?
|
View Answer
|
|
minvalue.sql Select the Nth lowest value from a table
|
View Answer
|
|
maxvalue.sql Select the Nth Highest value from a table
|
View Answer
|
|
What is the purpose of a cluster?
|
View Answer
|
|
What is a cursor?
|
View Answer
|
|
Difference between an implicit & an explicit cursor.
|
View Answer
|