To Add Delay to Execute Command or Query

--we need to add (waitfor delay 'hh:mm:ss')
--ex:
 select * from table1 waitfor delay '00:00:50'
--it will show output after 50 seconds