My select statement is not working as expected, So, to overcome from such issues

My select statement is not working as expected, So, to overcome from such issues what are the steps needed to be taken care?

Question Posted / dev

2 Answers
4525 Views
CG, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

My select statement is not working as expected, So, to overcome from such issues what are the steps ..

Answer / nitin

Possibe Scenarios
1. Check table is being locked by any other resourse.
2. Table reach to HIGH WATER MARK, resuse the storage or SHINK SPACE could overcome this problem.
3. Check the data volume.
4. Table or index(if any) is analysed or their stats are gather or not.

Is This Answer Correct ?

2 Yes

0 No

My select statement is not working as expected, So, to overcome from such issues what are the steps ..

Answer / nitinsharma06

1.Table is being Locked by any other resourse or not.
2.Table is reach to high water mark, REUSE STORAGE or SHRINK SPACE could resolve the issue.
3.Table or Indx(if any) stats are gather or not.

Is This Answer Correct ?

2 Yes

0 No

Post New Answer

More SQL PLSQL Interview Questions

What is the maximum number of rows in sql table?

0 Answers

Is oracle sql free?

0 Answers

Differentiate pl/sql and sql?

0 Answers

Write a query to genarate target column.Please answer me. Advance Thanks. Src Tgt Q10 Quarter to 2010 Q90 Quarter to 1990 Q80 Quarter to 1980 Q74 Quarter to 1974

5 Answers Infosys,

What is orm in sql?

0 Answers

Where the sql database files are stored?

0 Answers

take one table is t1 and in that column name is f1 f1 column values are 200 5000 3000 7000 300 600 100 400 800 400 i want display the values asc and desc in a single output. sample output is f1.a 100 200 300 400 500 600 etc...... and f1.d is 5000 4000 3000 2000 1000 etc...

9 Answers Zensar,

how to check the 3rd max salary from an employee table? One of the queries used is as follows: select sal from emp a where 3=(select count(distinct(sal)) from emp b where a.sal<=b.sal). Here in the sub query "select count(distinct(sal)) from emp b where a.sal<=b.sal" or "select count(distinct(sal)) from emp b where a.sal=b.sal" should reveal the same number of rows is in't it? Can any one here please explain me how is this query working perfectly. However, there is another query to get the 3rd highest of salaries of employees that logic I can understand. Pls find the query below. "select min(salary) from emp where salary in(select distinct top 3 salary from emp order by salary desc)" Please explain me how "select sal from emp a where 3=(select count(distinct(sal)) from emp b where a.sal<=b.sal)" works source:http://www.allinterview.com/showanswers/33264.html. Thanks in advance Regards, Karthik.

4 Answers

What is the starting oracle error number? What is meant by forward declaration in functions?

0 Answers

What is the purpose of design view?

0 Answers

How to display the records between two range in Oracle SQL Plus?

0 Answers MCN Solutions,

How do I upgrade sql?

0 Answers

For more SQL PLSQL Interview Questions Click Here