SQL PLSQL Interview Questions
Questions Answers Views Company eMail

how to find 5th row ?

10 14471

how to retrieve last tree records from table? select *from emp where rownum > (select count(*)-3 from emp); i am using this query to get last three records from table but its not giving any output, so please tell me what is the error in this query.

16 19523

how do you restrict number of rows for a particular value in a column.For example:there is a table called fruits,having apples,bananas ,papayas.I dont want to have more than 100 apples in that table ,so how can u restrict number of rows for apple to hundred?

6 9553

If a procedure within a package is invalidated whether the entire package will be invalid and has to be recompiled again?

IBM, TCS,

2 7764

write a query find which rows of a table is updated on 2 days before?

TCS,

3 7790

how to give permission to users that users can update/insert/delete on a row of table on timeing 10am to 6pm only?

TCS,

4 10520

SELECT ROUND(TRUNC(MOD(1600,10),-1),2) FROM dual;

10 73355

How can I create a table from another table without copying any values from the old table?

8 10607

in table there r so many rows write a query which two rows r updated last two day befor?

Exilant,

3 8863

How to remove duplicate rows from a table?.

3 6723

There is a table, In one column it has implemented a index, but the index is disturbed by the regular dml statements.. but still we need to keep the index. how it is possible?

Cognizant,

1 5684

Suppose I have to create a view on a table, that is not yet been created by DBA. I khow the table structure. Is it possible to create the view before DBA creates this table? If yes then how? Is it possible to create synonym in this way?

IBM, Metric Stream,

4 11071

I have one table,in that table (1)i have java1.1 version books are 2 and java1.5 version books are 4. (2).Net2.0 books are 3, .Net3.5 books are 2 (3)ABC1.6 books are 4, ABC2.0 books are 3. Now i want output is like Book Count Java 6 .Net 5 ABC 7 For this i need sql query, please help me if anyone how to get this result. Thanks, Seenu

Adea,

4 5345

what is data integrity

Fidelity, TCS,

3 10993

what is sql optimization

Fidelity,

1 8026


Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

Explain the difference between 'between' & 'and' operators in sql

503


Is sqlite thread safe?

583


What is the unique index?

502


What are the types of keys?

492


how to include character strings in sql statements? : Sql dba

530






What are tables and fields?

558


How much ram can sql express use?

481


Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql

504


What are local and global variables and their differences?

564


How do I view a procedure in sql?

525


How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?

562


Why coalesce is used in sql?

451


how to use regular expression in pattern match conditions? : Sql dba

505


What is the difference between distinct and unique in sql?

453


What is asqueryable?

507