Em Andamento

SQL Query

I want a sql query in which

i should be able to update a column value for rownumber s 1 to 15.

in SQL 2005 ROW_NUMBER() will give you row numbers of any table or column.

EX: Name

13

15

4

6

10

then for this column i should be able to change the column value for rows 1 to 3

I JUST NEED A SQL QUERY.

ex: update tablename set Name = 1 where Row_Number() <=1 and Row_Number >=1 and Row_Number <=3.

then output Name

1

1

1

6

10

this syntax is just an example i want the working query in SQL but not MYSQL.

## Deliverables

Below is the query which gives gives the column LetterGrade values order by ASC from Rownumber 1 to 15.

(SELECT LetterGrade

FROM (SELECT LetterGrade, ROW_NUMBER() OVER (ORDER BY LetterGrade ASC) AS RowNumber

FROM jig2) AS emp1

WHERE RowNumber >= 1 AND RowNumber <= 15)

use this query to update those 15 values of this column.

the query is something like this but this is not working exactly. so modify this and try.

update jig2 set LetterGrade = '1' where LetterGrade IN(SELECT LetterGrade

FROM (SELECT LetterGrade, ROW_NUMBER() OVER (ORDER BY LetterGrade ASC) AS RowNumber

FROM jig2) AS emp1

WHERE RowNumber >= 1 AND RowNumber <= 15)

## Platform

SQL

Habilidades: Engenharia, MySQL, PHP, Arquitetura de software, Teste de Software, SQL

Ver mais: n query, SQL Query, query table, php mysql sql example, order query platform, mysql update values, sql select select, update values mysql, sql select order, mysql output table, sql select, php sql update, mysql sql syntax, value engineering, sql syntax, modify query, mysql update select query, mysql query example, mysql row order, sql update, mysql column row, need sql query, mysql update column, sql query sql query, update sql php

Acerca do Empregador:
( 3 comentários ) United States

ID do Projeto: #2960952

Premiar a:

aiki2shinvw

See private message.

$2 USD em 1 dia
(8 Avaliações)
2.0

13 freelancers estão ofertando em média $19 para este trabalho

gopisoft

See private message.

$25.5 USD em 1 dia
(59 Comentários)
5.8
alex13vw

See private message.

$17 USD em 1 dia
(46 Comentários)
5.2
yubor

See private message.

$21.25 USD em 1 dia
(31 Comentários)
4.4
farhan83vw

See private message.

$8.5 USD em 1 dia
(19 Comentários)
3.2
jbrierley

See private message.

$11.05 USD em 1 dia
(7 Comentários)
2.4
meritcoder

See private message.

$29.75 USD em 1 dia
(1 Comentário)
1.6
bindatype

See private message.

$8.5 USD em 1 dia
(3 Comentários)
1.4
databytesconsult

See private message.

$19.55 USD em 1 dia
(4 Comentários)
1.3
scriptlancevw

See private message.

$85 USD em 1 dia
(5 Comentários)
1.3
paulec

See private message.

$8.5 USD em 1 dia
(0 Comentários)
0.0
sathishkumarh

See private message.

$4.25 USD em 1 dia
(0 Comentários)
0.0
frkbucv

See private message.

$8.5 USD em 1 dia
(1 Comentário)
0.0