How to fetch alternate records from a table?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL PLSQL Interview Questions

how to eliminate null values in a column i.e table vlaues 1 2 3 NULL 3 4 1 5 NULL i want output like this 1 2 3 3 4 1 5 i dnt want to use nvl is null and i dnt want replace the NULL value with any value i.e nvl(col,o);

11 Answers   Satyam,


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

4 Answers   TCS,


How bulk collect improves performance?

0 Answers  


What is ROWID?

8 Answers  


How to get the procedure's, function's name from a package if it is wrapped(both spec & body).

2 Answers  






Do triggers have restrictions on the usage of large datatypes, such as long and long raw?

0 Answers  


What does cursor do in sql?

0 Answers  


What is rowid in sql?

0 Answers  


Does sql use python?

0 Answers  


What are sql data types?

0 Answers  


What is sql used for?

0 Answers  


select sal from emp group by sal

3 Answers   TCS,


Categories