how to limit repeated value of a colunm in inserting values

Joma Alrzini

9y890

I tried this

update Student set Sup_Name =(select top 1 Supervisors.Sup_Name from Supervisors order by newid())where student.St_ID = '98754'

and I used update beuase I need to insert into one column

7 Replies

Know the answer? Post it — somebody with the same question will find it here.

Amit Gupta9y ago
Accepted answer
Why won't you check your condition in your program that if the particular query was ececuted more than 3 times then throw exception?
+1
Joma Alrzini9y ago
Thanks Amit

How can I throw exception in the query
+1
Nilesh Shah9y ago
Sadly you are not yet able to express your problem statement.
is there any error? explain using some table what is not working
0
Joma Alrzini9y ago
thanks Nilsh

I mean insert into the column e same value into the column e.g insert abc into column 3 times and when you insert it for 4th time the condition in query prevent inserting
+1
Nilesh Shah9y ago
I think you need to clarify your question
what do you mean by insert 3 time in a column?
what do you mean by the query prevent this insert? is there some error?

give us example using data
0
Joma Alrzini9y ago
Thanks Rajkiran

I don't neet to select unique value but I neet to insert the value into a column
only 3 time for example and when I try to insert the same for more than 3 times the query prevent this insert

Please help
+1
Rajkiran Swain9y ago
Use the DISTINCT keywords after SELECT statement
As in
```
SELECT DISTINCT * FROM ...
```
-2