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?

Comments

Popular posts from this blog

Script to find sessions that are blocking other sessions in PostgreSQL

How to find the server is whether standby (slave) or primary(master) in Postgresql replication ?

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

PostgreSQL pgBadger

PostgreSQL 9.6 idle_in_transaction_session_timeout parameter