Drop Down MenusCSS Drop Down MenuPure CSS Dropdown Menu

Basic SQL Interview Questions

1. What is difference between decode and case?
2. How will you delete duplicate records?
3. how will select first 5 records from a table?
4. what are the psedu columns?
5. Difference between delete and truncate?
6. What are the type of constraints?
7. Under which constraints the index will be created?
8. What is the difference between union and union all?
9. How will you fetch nth max salary?
10. Difference between inner join and outer join?


Popular posts from this blog

How to Get Table Size, Database Size, Indexes Size, schema Size, Tablespace Size, column Size in PostgreSQL Database

Postgres Database Patch

PostgreSQL Database startup / shutdown /restart

ORA-01261: Parameter db_recovery_file_dest destination string cannot be translated ORA-01262: Stat failed on a file destination directory Linux-x86_64 Error: 2: No such file or directory

PostgreSQL Pgbadger Installation On Linux