将文件拖动至此

SQL 上传 ( 0 ) x -

服务器: localhost »数据库: NorenDionNewsData »表: SecurityMaster
页面相关设置 点击以滚动到页面顶部
按 Ctrl+Enter 键执行查询 按 Enter 执行查询
递增排序
递减排序
命令:
调试 SQL
数量
运行顺序
用时
排序条件:
联合查询
不使用联合查询
崩溃 扩展 显示跟踪 隐藏跟踪 数量 用时
书签
刷新
添加
没有书签
添加书签
选项
恢复默认





崩溃 扩展 重新查询 编辑 解析 性能分析 书签 查询失败 数据库 : 查询时间 :

浏览模式

自定义浏览模式。

文档 仅使用图标、文字或都使用。
文档 仅使用图标、文字或都使用。
文档 设置是否给用户显示一个 "显示所有 (记录)" 的按钮。
文档 浏览结果集时显示的行数。若结果集总行数超过该值,将会显示 "上一页" 和 "下一页" 的链接。
文档 SMART - 即对 TIME、DATE、DATETIME 和 TIMESTAMP 类型的字段递减排序,其它字段递增。
文档 高亮鼠标指针所在的行。
文档 高亮选中的行。
文档
文档
文档 每 X 单元格重复表头,要禁止此功能请设为 0
文档 浏览非数字字段时最多显示的字数。
文档 这些是编辑、复制和删除链接。
文档 缺少唯一键时是否显示行链接。
文档 默认用主键为表排序。
文档 当浏览表时使用上次的排序方式。
文档 显示选项
正在显示第 0 - 24 行 (共 24292 行, 查询花费 0.0222 秒。) [MarketLot: 0... - 0...]
SELECT * FROM `SecurityMaster` ORDER BY `MarketLot`  ASC 
完整内容 CompanyCodeSecurityTypeCodeSecuritySubTypeCodeSerialNumberSecurityCodeTickerIssuePriceDescriptionDateOfIssueDateOfExpiryFaceValueMarketLot 递增 递减 1ISINCodeRemarksReasonForModificationIsItActiveSecurityDeleteFlagModifiedDate
0.00 0 0 0 SecurityCode Ticker 0.00 Description DateOfIssue DateOfExpiry 0.00 0 ISINCode Remarks ReasonForModification 0 0 ModifiedDate
10510001.00 7 1 1 010510001.00007001001 "AshokLe.(GDR" 12.79 "Ashok Leyland Ltd. (GDR)" "1995-03-31" "" 0.00 0 "USY0266N1192" "Information For Ashok Leyland Ltd. (GDR)" "Fresh Entry" 0 0 "2001-11-22 18:50:43"
10510001.00 24 4 1 010510001.00024004001 "AshkLeyNCB" 0.00 "Ashok Leyland Ltd.  (NC B)" "" "" 0.00 0 NULL "Information For Ashok Leyland Ltd.  (NC B)" "Porting" 0 0 "2001-11-22 16:44:46"
10510001.00 68 4 1 010510001.00068004001 "AshkLeyNC80" 0.00 "Ashok Leyland Ltd. (RT SR V) 12.5%" "" "" 0.00 0 NULL "Information For Ashok Leyland Ltd. (RT SR V) 12.5... "Porting" 0 0 "2001-11-22 18:50:43"
10510001.00 173 4 1 010510001.00173004001 "CBM479" 0.00 "ASHOK LEYLAND 9.60% 18S-AL 22" "2013-06-21" "2018-06-21" 100.00 0 "INE208A07364" "Information For ASHOK LEYLAND 9.60% 18S-AL 22" "CBM" 0 0 "2018-03-28 08:56:00"
10510005.02 5 4 1 010510005.02005004001 "HM Export" 0.00 "HM Export Ltd." "" "" 10.00 0 "INE962L01010" "Information For HM Export Ltd." "Added as per IB request" 0 0 "2013-02-08 17:45:00"
10510008.00 7 1 1 010510008.00007001001 "TELCO(GDR" 14.25 "Tata Motors Ltd. (GDR)" "1996-08-31" "" 0.00 0 NULL "Information For Tata Motors Ltd. (GDR)" "Fresh Entry" 1 0 "2004-09-29 00:00:00"
10510008.00 24 4 1 010510008.00024004001 "TELCO (NC-B)" 0.00 "Tata Engineering & Locomotive Company Ltd. (NC-B)... "" "" 0.00 0 NULL "Information For Tata Engineering & Locomotive Com... "Porting" 0 0 "2001-11-22 16:44:47"
10510008.00 28 4 1 010510008.00028004001 "TELCO-WAR01" 0.00 "Tata Motors Ltd. (Warrant 2001)" "" "" 0.00 0 "INE155A13019" "Warrants issued along with 7% Secured Convertible... "Fresh Entry" 1 0 "2003-08-30 00:00:00"
10510008.00 80 1 1 010510008.00080001001 "Tata Mot(ADR" 0.00 "Tata Motors Ltd. (ADR)" "" "" 0.00 0 NULL "Information For Tata Motors Ltd." "Fresh Entry" 1 0 "2005-02-16 19:16:45"
10510008.00 81 1 1 010510008.00081001001 "Tata Mo CP1" 0.00 "Tata Motors Ltd. - 90D CP - PVT - DOM: 29/11/2018... "" "2018-11-29" 500000.00 0 "INE155A14OP6" "Information For Tata Motors Ltd. - 90D CP - PVT -... "Coded for IVL" 0 0 "2020-05-22 15:41:00"
10510008.00 81 1 2 010510008.00081001002 "Tata Mo CP2" 0.00 "Tata Motors Ltd. - 265D CP - PVT - DOM: 20/03/201... "" "2019-03-20" 500000.00 0 "INE155A14OD2" "Information For Tata Motors Ltd. - 265D CP - PVT ... "Coded for IVL" 0 0 "2020-06-04 13:29:00"
10510008.00 173 4 1 010510008.00173004001 "CBM127" 0.00 "TATA MOTORS 8.00% 2019 E27-D" "2016-08-01" "2019-08-01" 100.00 0 "INE155A08308" "Information For TATA MOTORS 8.00% 2019 E27-D" "CBM" 0 0 "2018-03-24 23:52:00"
10510008.00 173 4 2 010510008.00173004002 "CBM193" 0.00 "TATA MOTORS 9.45% 18(E24-F)" "2012-10-23" "2018-03-29" 100.00 0 "INE155A08126" "Information For TATA MOTORS 9.45% 18(E24-F)" "CBM" 0 0 "2018-03-25 16:50:00"
10510008.00 173 4 3 010510008.00173004003 "CBM259" 0.00 "TATA MOTORS 7.50% 21 SR 27E" "2016-10-20" "2021-10-20" 100.00 0 "INE155A08316" "Information For TATA MOTORS 7.50% 21 SR 27E" "CBM" 0 0 "2018-03-26 09:30:00"
10510008.00 173 4 4 010510008.00173004004 "CBM271" 0.00 "TATA MOTRS 9.73% 2020 E26-DOII" "2014-10-01" "2020-10-01" 100.00 0 "INE155A08225" "Information For TATA MOTRS 9.73% 2020 E26-DOII" "CBM" 0 0 "2018-03-26 10:18:00"
10510008.00 173 4 5 010510008.00173004005 "CBM327" 0.00 "TATA MOTORS 8.40% 2021E 27B" "2016-05-26" "2021-05-26" 100.00 0 "INE155A08282" "Information For TATA MOTORS 8.40% 2021E 27B" "CBM" 0 0 "2018-03-26 15:23:00"
10510008.00 173 4 6 010510008.00173004006 "CBM344" 0.00 "TATA MOTORS 8.25% 2019 E 27-A" "2016-04-27" "2019-01-28" 100.00 0 "INE155A08274" "Information For TATA MOTORS 8.25% 2019 E 27-A" "CBM" 0 0 "2018-03-26 16:23:00"
10510008.00 173 4 7 010510008.00173004007 "CBM354" 0.00 "TATA MOTORS 8.13% 18 (E27-C)" "2016-07-18" "2018-07-18" 100.00 0 "INE155A08290" "Information For TATA MOTORS 8.13% 18 (E27-C)" "CBM" 0 0 "2018-03-26 16:34:00"
10510008.00 173 4 8 010510008.00173004008 "CBM422" 0.00 "TATA MOT 9.69% 2019 (E24-E)" "2012-10-10" "2019-03-29" 100.00 0 "INE155A08118" "Information For TATA MOT 9.69% 2019 (E24-E)" "CBM" 0 0 "2018-03-27 15:33:00"
10510008.00 173 4 9 010510008.00173004009 "CBM491" 0.00 "TATA MOTORS 9.70% 2020 (E23-C)" "2010-06-18" "2020-06-18" 100.00 0 "INE155A08068" "Information For TATA MOTORS 9.70% 2020 (E23-C)" "CBM" 0 0 "2018-03-28 09:15:00"
10510008.00 173 4 10 010510008.00173004010 "CBM499" 0.00 "TATA MOT 10.30% 2018 (E26-A)" "2013-12-16" "2018-11-30" 100.00 0 "INE155A08183" "Information For TATA MOT 10.30% 2018 (E26-A)" "CBM" 0 0 "2018-03-28 09:24:00"
10510008.02 5 4 1 010510008.02005004001 "Tata Techno" 0.00 "Tata Technologies Ltd." "" "" 2.00 0 "INE142M01025" "Information For Tata Technologies Ltd." "Added for TSL" 0 0 "2023-05-26 13:32:00"
10520003.00 7 1 1 010520003.00007001001 "MandM(GDR" 4.46 "Mahindra & Mahindra Ltd. (GDR)" "1993-11-30" "" 0.00 0 NULL "Information For Mahindra & Mahindra Ltd. (GDR)" "Fresh Entry" 1 0 "2003-02-19 00:00:00"
10520003.00 24 4 1 010520003.00024004001 "Mah&Mah   NC" 0.00 "Mahindra & Mahindra Ltd. (NCD)" "" "" 0.00 0 NULL "Information For Mahindra & Mahindra Ltd. (NCD)" "Porting" 0 0 "2001-11-22 16:44:48"