如何从sql表中选择recrod？ [英] How to select recrod from sql table?

问题描述

大家好，

我有一个包含SelBuy标志的表。我的表看起来像，

 IF OBJECT_ID（N'tempdb ..＃tmpList'，N'U'）IS NOT NULL 
开始
 DROP TABLE #tmpList; 
结束
创建表#tmpList 
（
 SelSRNO Bigint，
 SelRate Float，
 SelQty Float，
 BuySrno Bigint，
 BuyRate Float，
 BuyQty Float，
 SelBuy varchar（20），
 CustName varchar（50）
）
 
 INSERT into #tmpList（SelSRNO，SelRate ，SelQty，BuySrno，BuyRate，BuyQty，SelBuy，CustName）
选择1 SelSRNO，10 SelRate，10 SelQty，0 BuySrno，0 BuyRate，0 BuyQty，'S'SelBuy，'Manoj'CustName 
 Union 
选择2 SelSRNO，12 SelRate，12 SelQty，0 BuySrno，0 BuyRate，0 BuyQty，'S'SelBuy，'Manoj'CustName 
 Union 
选择0 SelSRNO，0 SelRate，0 SelQty ，7 BuySrno，40 BuyRate，30 BuyQty，'B'SelBuy，'Manoj'CustName 
 Union 
选择3 SelSRNO，22 SelRate，24 SelQty，0 BuySrno，0 BuyRate，0 BuyQty，'S' SelBuy，'MANOJ-1'CustName 
 Union 
选择0 SelSRNO，0 SelRate，0 SelQty，7 BuySrno，110 BuyRate，120 BuyQty，'B'SelBuy，'MANOJ-1'CustName 
 Union 
选择0 SelSRNO，0 SelRate，0 SelQty，9 BuySrno，40 BuyRate，40 BuyQt y，'B'SelBuy，'MANOJ-1'CustName 
选择*来自#tmpList 
按CustName排序，SelBuy描述

我想根据SelBuy Flag选择记录Sel和Buy。

选择记录如，

 SelSRNO SelRate SelQty BuySrno BuyRate BuyQty CustName 
 1 10 10 7 40 30 Manoj 
 2 12 12 0 0 0 Manoj 
 3 22 24 7 110 120 MANOJ-1 
 0 0 0 9 40 40 MANOJ-1 

请帮助我选择此格式的选择记录。

解决方案

A select语句对于SQL来说是如此基础 - 也许是最基本的。因此，我建议您访问本网站：  [click] [ ^ ]



由于语言的结构如何，如果可以的话掌握SELECT您可以完成90％的需要。其余的都有时间。



祝你好运

Hello all,
I have one table which contain SelBuy flag. My table looks like,

IF OBJECT_ID(N'tempdb..#tmpList', N'U') IS NOT NULL 
Begin
	DROP TABLE #tmpList;
End
Create Table #tmpList
(
	SelSRNO Bigint,
	SelRate Float,
	SelQty Float,
	BuySrno Bigint,
	BuyRate Float,
	BuyQty Float,
	SelBuy varchar(20),
	CustName varchar(50)
)

INSERT Into #tmpList(SelSRNO,SelRate,SelQty,BuySrno,BuyRate,BuyQty,SelBuy,CustName)
Select 1 SelSRNO,10 SelRate,10 SelQty,0 BuySrno,0 BuyRate,0 BuyQty,'S' SelBuy,'Manoj' CustName
Union 
Select 2 SelSRNO,12 SelRate,12 SelQty,0 BuySrno,0 BuyRate,0 BuyQty,'S' SelBuy,'Manoj' CustName
Union 
Select 0 SelSRNO,0 SelRate,0 SelQty,7 BuySrno,40 BuyRate,30 BuyQty,'B' SelBuy,'Manoj' CustName
Union 
Select 3 SelSRNO,22 SelRate,24 SelQty,0 BuySrno,0 BuyRate,0 BuyQty,'S' SelBuy,'MANOJ-1' CustName
Union 
Select 0 SelSRNO,0 SelRate,0 SelQty,7 BuySrno,110 BuyRate,120 BuyQty,'B' SelBuy,'MANOJ-1' CustName
Union 
Select 0 SelSRNO,0 SelRate,0 SelQty,9 BuySrno,40 BuyRate,40 BuyQty,'B' SelBuy,'MANOJ-1' CustName
Select * from #tmpList
Order By CustName,SelBuy Desc

I want to select record Sel and Buy based on SelBuy Flag.
Selectd record like,

SelSRNO	SelRate	SelQty	BuySrno	   BuyRate	BuyQty	CustName
1	    10	     10	      7	       40	    30	  Manoj
2	    12	     12	      0	        0	     0	  Manoj
3	    22	     24	      7	      110	   120	  MANOJ-1
0	     0	      0	      9	       40	    40	  MANOJ-1

Please help me for select record in this format.

解决方案

A select statement is so basic to SQL - perhaps the most basic of all. For that reason, I recommend you to this website:  [click][^]

Because of how the language is structured, if you can master SELECT you can get through perhaps 90% of what you'd need to do. The remainder comes with time.

Good Luck

这篇关于如何从sql表中选择recrod？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！