SQL queries : ———————- 1. Difference between Delete & Truncate ? 2. Difference between Order By & Group By? 3. If there are 11 table how many joins will be used to join all of them ? 4. How to retrieve number of records from table ? 5. Retrieve highest second salary record from 2 tables ? 6. How many joins are there ? What are they ? 7. Difference between union & union all ? 8. How to retrieve different data with out duplicate values ? 9. Aggregate functions & details ? 10. Normalization ? 11. Views & indexes on tables ? 12. How do u compare tables or databases ? 13. Do u have any exp. in MySQL , db2, sql server ? 14. Question about unique ? 15. Question about primary key ? 16. Creating stored procedures ? Etc
