Red
We have many things to learn from others.
Friday, 1 October 2021
Select odd and even rows in the SQL
CREATE
TABLE
#TEST
(
ID
INT
IDENTITY
(
1
,
1
),
ROWID
uniqueidentifier
)
GO
INSERT
INTO
#TEST
(
ROWID
)
VALUES
(
NEWID
())
GO
10
--drop table #TEST
select
*
from
#TEST
where
Id
%
2
=
0
--Even
select
*
from
#TEST
where
Id
%
2
!=
0
--Odd
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
split FullName column to FirstName, MiddleName, LastName column in MS SQL
split data table by rows c#
"type":"https://tools.ietf.org/html/rfc7231#section-6.5.1","title":"One or more validation errors occurred.","status":400
An INSERT EXEC statement cannot be nested.
No comments:
Post a Comment