How can I Update top 10 records in SQL Server


Hello, guys suppose we have to update the top 10 records in the table, the following query may help you.
CREATE TABLE #TMP
(
ID INT IDENTITY(1,1),
NAME VARCHAR(100),
SALARY DECIMAL(16,2)
)

INSERT INTO #TMP
SELECT 'N1',20000
UNION ALL
SELECT 'N2',15000
UNION ALL
SELECT 'N3',20000
UNION ALL
SELECT 'N4',30000
UNION ALL
SELECT 'N5',10000
UNION ALL
SELECT 'N6',25000
UNION ALL
SELECT 'N7',10000
UNION ALL
SELECT 'N8',50000
UNION ALL
SELECT 'N9',20000
UNION ALL
SELECT 'N10',20000
UNION ALL
SELECT 'N11',30000
UNION ALL
SELECT 'N12',40000
UNION ALL
SELECT 'N13',50000

SELECT * FROM #TMP


UPDATE TOP (10) #TMP SET SALARY=10000




SELECT * FROM #TMP

No comments:

Post a Comment

Please do not enter any spam link in the comment box.

Related Posts

Fatal Error: Peer authentication failed for user "postgres", when trying to get pgsql working with rails.

Problem: Sometimes, we get the following error when trying to make a connection in Rails.  FATAL ERROR: Peer authentication failed for us...