How to get last inserted record without top/max clause
Are you looking for a way to get last inserted record in sql ? want to do it without top/max clause ? then read this thread to know more about it
Please send me SQL Queries which are asking in interview for experienced person.
On Saturday, I faced one interview in .net but they give me one paper that contain only SQL query question's and write query.
One question that i remember is :
How do we get the value of the identity column of the last inserted records without using a Max / Top clause.
And other queries related to group by and having clause.
So send me queries on this.