trickey sql query

[duraisamy]

I have a doubt in which sql statement takes more time to execute.

1.select
2.insert
3.delete
4.update
5.merge

[michaelb]

It is impossible to answer this question without context.

[suvam]

It depends on the context parameters .
But normally the order is --->

Merge < Update < delete < insert <select ,when Record count is same for all .