Where can i get sql queries along with their answers which are asked during interviews?

Question

I want queries like find second largest no or queries involving join,count and other things.

Answer 1

There are no standard interview queries that I'm aware of (and, having been a consultant for over 20 years, I'm pretty sure I'd know if there were.) My best advice is to actually learn SQL...most technical interviewers (the competent ones, anyway) should be able to tell pretty quick if someone's trying to BS their way thru.



Basic knowledge: SELECT structure including GROUP BY/HAVING and ORDER BY; INSERT, UPDATE and DELETE queries; difference between UNION/UNION ALL and inner/right_outer/left_outer/full_outer joins; various column types including conversions, CASTs and literals; date/time and other built-in functions; aliases; dealing with nulls



Moderate knowledge: views; correlated/noncorrelated subqueries; user functions, stored procedures; triggers; embedded SQL, scripting and cursors; constraints; query analysis and optimization; table/database/index/etc. create/drop; data dictionary interrogation; CASE and similar structures



Advanced knowledge: transaction commits and rollbacks; database backups and recoveries; user security and permissions; data/schema import/export (including XML); reporting (Crystal Reports, etc.) and interaction with applications (ODBC, server calls, etc.); dynamic SQL

Answer 2

The best way to answer such questions are by learning the SQL itself. There are many SQL tutorials in the internet and one of good ones are at w3schools. Check out their website on SQL .

Answer 3

Try http://www.sql-ex.ru/.

But you'll be forced to get answers by yourself. :-)