TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Anurag Singh
NA
89
64.9k
How to update only starting 5 rows???
Mar 2 2015 5:51 AM
Hi,
I have a table in SQL with a column
Name(varchar(50))
only. There are 100 records . There are names like as
A, B & C.
Suppose there are 30 Name like A, 30 Name like B and 40 are like C.
Names are like as in my sql table:
a
a
a
a
a
a
a
a
b
b
c
a
b
a
c
c
a
b
.....
Then I want to update only 5 starting rows(which contain Name A) as B.
Reply
Answers (
3
)
how can use in derived table in salserver
When i execute the sql query shows error