abhishek_300 (7/28/2015)
Thanks Gila monster for your comments .However for interviews people do not ask simple question on SQL hence you are seeing unrealistic example.
I can ask some very non-simple questions without imposing unrealistic restrictions on what may be used in a query.
Eg:
Write a query which shows the third set of 10 rows from a table, with the ordering imposed by the column TransactionTime.
What other methods could you have used?
What are the advantages and disadvantages of each method?
That's going to tell me a lot more about the person's ability to code, think and evaluate their code than asking them to do things like join two tables without using a join clause.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability