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
CRUD Operation With ASP.NET Core 3.1
An INSERT EXEC statement cannot be nested.
split data table by rows c#
No comments:
Post a Comment