将文件拖动至此

SQL 上传 ( 0 ) x -

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





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

浏览模式

自定义浏览模式。

文档 仅使用图标、文字或都使用。
文档 仅使用图标、文字或都使用。
文档 设置是否给用户显示一个 "显示所有 (记录)" 的按钮。
文档 浏览结果集时显示的行数。若结果集总行数超过该值,将会显示 "上一页" 和 "下一页" 的链接。
文档 SMART - 即对 TIME、DATE、DATETIME 和 TIMESTAMP 类型的字段递减排序,其它字段递增。
文档 高亮鼠标指针所在的行。
文档 高亮选中的行。
文档
文档
文档 每 X 单元格重复表头,要禁止此功能请设为 0
文档 浏览非数字字段时最多显示的字数。
文档 这些是编辑、复制和删除链接。
文档 缺少唯一键时是否显示行链接。
文档 默认用主键为表排序。
文档 当浏览表时使用上次的排序方式。
文档 显示选项
正在显示第 0 - 24 行 (共 24292 行, 查询花费 0.0448 秒。) [Description: "15% CRISIL SHORT TERM BOND FUND INDEX"... - "63 IDEAS INFOLABS PVT. LTD."...]
SELECT * FROM `SecurityMaster` ORDER BY `Description` ASC 
完整内容 CompanyCodeSecurityTypeCodeSecuritySubTypeCodeSerialNumberSecurityCodeTickerIssuePriceDescription 递增 递减 1DateOfIssueDateOfExpiryFaceValueMarketLotISINCodeRemarksReasonForModificationIsItActiveSecurityDeleteFlagModifiedDate
14010005.00 26 5 39 014010005.00026005039 "MF Bench6" 0.00 "15% CRISIL Short Term Bond Fund Index" "" "" 0.00 0 NULL "Information For 15% CRISIL Short Term Bond Fund I... "Coded for MF Purpose" 0 0 "2020-03-03 14:59:00"
17023929.00 26 5 198 017023929.00026005198 "MF Bench3" 0.00 "15% S&P BSE 200 TRI + 85% NIFTY AAA Short Duratio... "" "" 0.00 0 NULL "Information For 15% S&P BSE 200 TRI + 85% NIFTY A... "Coded for MF purpose" 0 0 "2019-11-14 16:14:00"
15110088.00 5 4 1 015110088.00005004001 "20 Microns" 45.00 "20 Microns Ltd." "2008-09-25" "" 5.00 1 "INE144J01027" "Information For 20 Microns Ltd." "Face value changed from Rs. 10/- to Rs. 5/-" 1 0 "2013-01-25 00:00:00"
15110141.00 5 4 1 015110141.00005004001 "20 Mic.Nano" 0.00 "20 Microns Nano Minerals Ltd." "" "" 10.00 0 "INE799W01013" "Information For 20 Microns Nano Minerals Ltd." "Coded for IVL" 0 0 "2020-10-28 13:29:00"
11250011.00 26 5 1 011250011.00026005001 "MF Bench7" 0.00 "20% iCOMDEX Composite Index" "" "" 0.00 0 NULL "Information For 20% iCOMDEX Composite Index" "Coded for MF Purpose" 0 0 "2020-03-03 15:03:00"
17023929.00 26 5 204 017023929.00026005204 "MF Bench9" 0.00 "20% Nifty 50 TRI Index" "" "" 0.00 0 NULL "Information For 20% Nifty 50 TRI Index" "Coded for MF Purpose" 0 0 "2020-03-03 15:15:00"
14050009.03 66 4 1 014050009.03066004001 "20CenCentOEF" 0.00 "20th Century Centurion Open End Fund" "" "2000-09-26" 0.00 0 NULL "Information For 20th Century Centurion Open End F... "Porting" 0 0 "2001-11-22 18:50:35"
14060002.00 5 4 1 014060002.00005004001 "20CenFinCorp" 0.00 "20th Century Finance Corporation Ltd." "" "" 10.00 100 NULL "De-listed" "Merged with Centurion Bank Ltd." 0 0 "2003-11-10 00:00:00"
14050009.01 5 4 1 014050009.01005004001 "20CenPrudent" 0.00 "20th Century Prudent" "" "" 10.00 100 NULL "Information For 20th Century Prudent" "Porting" 0 0 "2001-11-22 16:48:28"
14050009.02 5 4 1 014050009.02005004001 "20CenQtmGwth" 0.00 "20th Century Quantum" "" "" 10.00 100 NULL "Information For 20th Century Quantum" "Porting" 0 0 "2001-11-22 16:48:28"
17020803.00 5 4 1 017020803.00005004001 "21CentSteels" 0.00 "21st Century Steels Ltd." "" "" 10.00 100 NULL "Information For 21st Century Steels Ltd." "Porting" 0 0 "2002-01-03 00:00:00"
14010688.00 5 4 1 014010688.00005004001 "IIFL Wealth" 0.00 "360 One Wam Ltd." "" "" 1.00 1 "INE466L01038" "Company name changed from IIFL Wealth Management ... "FV changed from Rs. 2/- to Re. 1/-." 1 0 "2023-03-01 20:16:00"
17024249.00 5 1 1 017024249.00005001001 "3Com Corpora" 0.00 "3Com Corporation" "" "" 0.00 0 NULL "Information For 3Com Corporation (Nasdaq - 100)" "Fresh Entry" 1 0 "2002-02-17 13:32:38"
13190444.00 5 4 1 013190444.00005004001 "3D PLM Soft" 0.00 "3D PLM Software Solutions Ltd" "" "" 10.00 0 "INE657W01013" "Information For 3D PLM Software Solutions Ltd" "Added for IB Purpose" 0 0 "2017-04-05 16:30:00"
13190444.00 16 4 1 013190444.00016004001 "3D PLM RPS" 68.00 "3D PLM Software Solutions Ltd. - 7.00% Red. Pref ... "2017-03-20" "2018-06-20" 68.00 1 "INE657W04017" "Information For 3D PLM Software Solutions Ltd. - ... "No-dealings due to Redemption" 0 0 "2020-08-25 15:45:00"
13190098.00 5 4 1 013190098.00005004001 "3i Infotech" 90.00 "3i Infotech Ltd." "2005-03-30" "" 10.00 1 "INE748C01038" "Information For 3i Infotech Ltd." "FV changed from Rs. 10/- to Re. 1/- on a/c of RoC... 1 0 "2021-11-08 17:23:00"
17010019.00 5 4 1 017010019.00005004001 "3M India" 0.00 "3M India Ltd." "" "" 10.00 1 "INE470A01017" "Company name changed from Birla 3M Ltd. to 3M Ind... "Name changed" 1 0 "2004-09-17 00:00:00"
11070110.00 5 4 1 011070110.00005004001 "PudmjeAgroIn" 0.00 "3P Land Holdings Ltd." "" "" 2.00 1 "INE105C01023" "Company name changed from Pudumjee Agro Industrie... "Face value changed from Rs. 10/- to Rs. 2/-." 1 0 "2018-05-03 20:55:00"
17040841.00 5 4 1 017040841.00005004001 "3rd Rock" 0.00 "3rd Rock Multimedia Ltd." "" "" 10.00 0 "INE768P01012" "Information For 3rd Rock Multimedia Ltd." "SME Emerge - ITP (Market Lot - Rs. 10,00,000/-)" 1 0 "2014-11-28 18:56:00"
14010005.00 26 5 41 014010005.00026005041 "MF Bench10" 0.00 "50% Crisil Short Term Gilt Index" "" "" 0.00 0 NULL "Information For 50% Crisil Short Term Gilt Index" "Coded for MF Benchmark" 0 0 "2020-07-16 12:19:00"
17023928.00 26 5 239 017023928.00026005239 "MF Bench2" 0.00 "50% S&P BSE 200 TRI + 50% NIFTY AAA Short Duratio... "" "" 0.00 0 NULL "Information For 50% S&P BSE 200 TRI + 50% NIFTY A... "Coded for MF Purpose" 0 0 "2019-11-14 16:13:00"
11110067.00 5 4 1 011110067.00005004001 "SS Aquakult" 50.00 "52 Weeks Entertainment Ltd." "1995-05-30" "" 10.00 1 "INE545N01019" "Company name changed from Shantanu Sheorey Aquaku... "Suspension revoked" 1 0 "2015-12-08 00:00:00"
14010689.00 5 4 1 014010689.00005004001 "5Paisa Cap" 0.00 "5Paisa Capital Ltd." "" "" 10.00 1 "INE618L01018" "Information For 5Paisa Capital Ltd." "New listing" 1 0 "2017-11-15 15:04:00"
14010463.00 29 1 1 014010463.00029001001 "UTI ARS Bond" 0.00 "6.60% Tax Free Government Guaranteed ARS bonds (U... "" "" 100.00 1 "INE189A07028" "Information For Administrator of the Specified Un... "Suspended due to Redemption" 0 0 "2009-02-26 00:00:00"
13192782.00 5 4 1 013192782.00005004001 "63 IdeasInfo" 0.00 "63 Ideas Infolabs Pvt. Ltd." "" "" 10.00 0 "INE188W01019" "Information For 63 Ideas Infolabs Pvt. Ltd." "Coded for IVL" 0 0 "2020-07-25 18:29:00"