Sample Table Job_ID Job_Name Status 1 TEST00001 FOR KE 2 TEST00002 FOR KE 3 TEST00003 FOR KE 4 TEST00004 FOR KE 5 TEST00005 FOR KE
I have sql query that will get a jobname where status is equal to 'FOR KE' and I have multiple users that will query that.
Now, what if two queries was executed at the same time? Will the two users get the same jobname? How can I avoid that?
Thanks in advance.