create table tblUser
(
UserId int identity(1,1) not null,
UserName nvarchar(500),
Age int
)
INSERT INTO tblUser select 'Rahul',26
INSERT INTO tblUser select 'Yunus',26
create table tblTransaction
(
TransactionId int identity(1,1) not null,
UserId int,
Amount int ,
Status bit
)
INSERT INTO tblTransaction SELECT 1,200,1
INSERT INTO tblTransaction SELECT 1,2100,1
INSERT INTO tblTransaction SELECT 1,900,1
INSERT INTO tblTransaction SELECT 1,60,1
INSERT INTO tblTransaction SELECT 2,200,1
INSERT INTO tblTransaction SELECT 2,2100,1
INSERT INTO tblTransaction SELECT 2,900,1
INSERT INTO tblTransaction SELECT 2,60,1
INSERT INTO tblTransaction SELECT 2,55,1
SELECT * FROM tblUser
SELECT * FROM tblTransaction
SELECT * FROM tblUser as U
INNER JOIN
(
SELECT * FROM tblTransaction
WHERE
TransactionId IN
(
SELECT MAX(TransactionId)
FROM
tblTransaction
GROUP BY UserId
)
) AS [A]
ON
U.UserId=A.UserId
Thursday, February 28, 2013
USE SUBQUERY IN INNER JOIN
Subscribe to:
Posts (Atom)
.net core
Sure, here are 50 .NET Core architect interview questions along with answers: 1. **What is .NET Core, and how does it differ from the tradi...
-
The error message you encountered ("DeleteService FAILED 1072: The specified service has been marked for deletion") indicates tha...
-
When running npx (with any arguments, but -v is easiest to test) from the global install folder, the following error is produced. ...