本文介紹了sql查詢以在簡單的兩個表中的let表中獲取不同的行的處理方法，對大家解決問題具有一定的參考價值，需要的朋友們下面隨著小編來一起學習吧！
問題描述
CREATE TABLE [dbo].[tbl_Travel](
[TE_ID] [int] IDENTITY(1,1) NOT NULL,
[TRAVEL_TYPE] [varchar](12) NULL,
[TRAVEL_MODE] [varchar](35) NULL,
[TRAVEL_CLASS] [nchar](10) NULL)
SET PRIMARY KEY TO TE_ID
INSERT INTO [TAMSMVC].[dbo].[tbl_Travel] VALUES ('Return', 'Airlines', 'Economy')
INSERT INTO [TAMSMVC].[dbo].[tbl_Travel] VALUES ('Single', 'Airlines', 'Business')
INSERT INTO [TAMSMVC].[dbo].[tbl_Travel] VALUES ('Return', 'Airlines', 'Business')
INSERT INTO [TAMSMVC].[dbo].[tbl_Travel] VALUES ('Single', 'Railway', 'Second')
INSERT INTO [TAMSMVC].[dbo].[tbl_Travel] VALUES ('Return', 'Railway', 'First')
CREATE TABLE [dbo].[tbl_Journey](
[JOURNET_ID] [int] IDENTITY(1,1) NOT NULL,
[TE_ID] [int] NULL,
[JOURNEY_FROM] [varchar](30) NULL,
[JOURNEY_TO] [varchar](30) NULL)
將主密鑰設(shè)置為 [JOURNET_ID]
SET PRIMARY KEY TO [JOURNET_ID]
INSERT INTO [TAMSMVC].[dbo].[tbl_Journey] VALUES (1,'Mumbai','PUNE')
INSERT INTO [TAMSMVC].[dbo].[tbl_Journey] VALUES (1,'PUNE','Mumbai')
INSERT INTO [TAMSMVC].[dbo].[tbl_Journey] VALUES (2,'BANGALORE','GOA')
INSERT INTO [TAMSMVC].[dbo].[tbl_Journey] VALUES (3,'CHENNAI','PANAJI')
INSERT INTO [TAMSMVC].[dbo].[tbl_Journey] VALUES (3,'PANAJI','CHENNAI')
INSERT INTO [TAMSMVC].[dbo].[tbl_Journey] VALUES (4,'DELHI','KOLKATA')
INSERT INTO [TAMSMVC].[dbo].[tbl_Journey] VALUES (5,'BHOPAL','SHIMALA')
INSERT INTO [TAMSMVC].[dbo].[tbl_Journey] VALUES (5,'SHIMALA','BHOPAL')
結(jié)果應(yīng)該是我想要表中不同的行
AND RESULT SHOULD BE i want distinct rows in the table
Journey_ID TE_ID Journey_From Journey_To TRAVEL_TYPE [TRAVEL_MODE TRAVEL_CLASS
1 1 Mumbai PUNE Return Airlines Economy
3 2 BANGALORE GOA Single Airlines Business
4 3 CHENNAI PANAJI Return Airlines Business
6 4 DELHI KOLKATA Single Railway Second
7 5 BHOPAL SHIMALA Return Railway First
結(jié)果應(yīng)該是我想要表中的不同行我想刪除第二個表中的重復行，并且最小它應(yīng)該顯示包含 min travel_id 的行
AND RESULT SHOULD BE i want distinct rows in the table i want to remove duplicate rows in second table and min it should show min journey_id contained rows
推薦答案
Journey_ID TE_ID Journey_From Journey_To TRAVEL_TYPE [TRAVEL_MODE TRAVEL_CLASS CountofTEID
1 1 Mumbai PUNE Return Airlines Economy 2
3 2 BANGALORE GOA Single Airlines Business 1
4 3 CHENNAI PANAJI Return Airlines Business 2
6 4 DELHI KOLKATA Single Railway Second 1
7 5 BHOPAL SHIMALA Return Railway First 2
null 6 null null Return Airlines Economy 0
null 7 null null Return Airlines Business 0
結(jié)果我想要 Travel table 中的所有行，所有旅程的計數(shù)和具有最小 travel_id 的單個記錄
In result Iwant all rows from Travel table , count of all journeys and single record with minimum journey_id
這篇關(guān)于sql查詢以在簡單的兩個表中的let表中獲取不同的行的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網(wǎng)！
【網(wǎng)站聲明】本站部分內(nèi)容來源于互聯(lián)網(wǎng),旨在幫助大家更快的解決問題，如果有圖片或者內(nèi)容侵犯了您的權(quán)益，請聯(lián)系我們刪除處理，感謝您的支持！