Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category
SQL PLSQL Interview Questions
Questions Answers Views Company eMail

how to find 5th row ?

 10 13466

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 18112

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 9014

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

IBM, TCS,

2 7389

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

TCS,

3 7336

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 9985

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

 10 61243

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

 8 9811

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

Exilant,

3 8400

How to remove duplicate rows from a table?.

 3 6389

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 5418

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 10505

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 4867

what is data integrity

Fidelity, TCS,

3 10179

what is sql optimization

Fidelity,

1 7508

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

Is mariadb a nosql database?

392

What is data manipulation language?

527

Why do we use subquery?

341

What is synonyms?

421

What is aggregate function in sql?

369




What is difference between stored function and application function?

450

How do I save a sql query?

394

What is snowflake sql?

396

what is a view? : Sql dba

442

What is sql injection vulnerability?

346

What is sql performance tuning?

348

Explain character-manipulation functions?

427

What can sql server reporting services do?

406

Are stored procedures faster than dynamic sql?

378

what are the performance and scalability characteristics of mysql? : Sql dba

370

For More Un-Answered { SQL PLSQL } Questions Click Here