将文件拖动至此

SQL 上传 ( 0 ) x -

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





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

浏览模式

自定义浏览模式。

文档 仅使用图标、文字或都使用。
文档 仅使用图标、文字或都使用。
文档 设置是否给用户显示一个 "显示所有 (记录)" 的按钮。
文档 浏览结果集时显示的行数。若结果集总行数超过该值,将会显示 "上一页" 和 "下一页" 的链接。
文档 SMART - 即对 TIME、DATE、DATETIME 和 TIMESTAMP 类型的字段递减排序,其它字段递增。
文档 高亮鼠标指针所在的行。
文档 高亮选中的行。
文档
文档
文档 每 X 单元格重复表头,要禁止此功能请设为 0
文档 浏览非数字字段时最多显示的字数。
文档 这些是编辑、复制和删除链接。
文档 缺少唯一键时是否显示行链接。
文档 默认用主键为表排序。
文档 当浏览表时使用上次的排序方式。
文档 显示选项
正在显示第 0 - 24 行 (共 14131 行, 查询花费 0.0141 秒。) [BusinessGroupCode: 0... - 10003...]
SELECT * FROM `CompanyMaster` ORDER BY `BusinessGroupCode`  ASC 
完整内容 CompanyCodeCompanyNameShortCompanyNameIndustryCodeIndustryNameBusinessGroupCode 递增 递减 1BusinessGroupNameIncorporationDateIncorporationYearFirstPublicIssueDateFirstPublicIssueYearMajorSectorCINNoRemarksModifiedDateDeleteFlag
0.00 "2016-03-10 14:33:41" False
0 NULL 0 NULL NULL NULL NULL NULL 0 NULL NULL NULL 0
11320014.00 2003 respectively.
NULL 0 NULL 0 NULL NULL NULL NULL NULL 0 NULL NULL NULL 0
12540414.00 "Paras Pharmaceuticals Ltd." "Paras Pharmaceutical" 254 "Pharmaceuticals" 1054 "Elf atochem SA" "" NULL "" NULL 1 NULL NULL "2007-03-23 16:35:10" 0
11600013.00 "Stewarts & Lloyds of India Ltd." "Stewarts & Lloy." 352 "Engineering - General" 2600 "Oiltanking Gmbh" "1937-08-18" "1937" "" NULL 1 "L28999WB1937PLC009099" NULL "2021-02-18 17:20:32" 0
11050008.00 "Arihant Agro Products Ltd." "Arihant Agro" 129 "Food Processing - Bakery/Dairy/Fruits/Others" 10001 "Arihant (Shreyans)" "" NULL "" NULL 1 NULL NULL "2018-09-27 16:38:55" 0
14060426.00 "Arihant Classic Finance Ltd." "Arihant Classic" 409 "Finance & Investments" 10001 "Arihant (Shreyans)" "1995-04-03" "1995" "1996-01-05" "1996" 1 "L65910GJ1995PLC025312" NULL "2016-03-10 14:33:36" 0
16040003.00 "Arihant Cotsyn Ltd." "Arihant Cotsyn" 604 "Textiles - Spinning - Synthetic Blended" 10001 "Arihant (Shreyans)" "1987-12-22" "1987" "1989-07-21" "1989" 1 "L17115PB1987PLC007880" NULL "2016-03-10 14:32:58" 0
14090091.00 "Arihant Capital Markets Ltd." "Arihant Capital" 409 "Finance & Investments" 10001 "Arihant (Shreyans)" "1992-06-25" "1992" "1994-10-17" "1994" 1 "L67120MP1992PLC007182" NULL "2016-03-10 14:32:56" 0
14090155.00 "Arihants Securities Ltd." "Arihants Securit" 409 "Finance & Investments" 10001 "Arihant (Shreyans)" "1995-04-19" "1995" "1995-06-08" "1995" 1 "L65993TN1994PLC027783" NULL "2016-03-10 15:27:01" 0
16040004.00 "Arihant Industries Ltd." "Arihant Indus." 613 "Textiles - Weaving" 10001 "Arihant (Shreyans)" "1977-03-11" "1977" "1987-08-08" "1987" 1 "U17115PB1977PLC003726" NULL "2016-03-10 14:32:58" 0
16030087.00 "Arihant Threads Ltd." "Arihant Threads" 603 "Textiles - Spinning - Cotton Blended" 10001 "Arihant (Shreyans)" "1992-02-14" "1992" "1994-11-28" "1994" 1 "L17111PB1992PLC012022" NULL "2016-03-10 14:32:58" 0
16610063.00 "Arihant Enterprise Ltd." "Arihant Enterpri" 556 "Steel - Sponge Iron" 10001 "Arihant (Shreyans)" "1994-09-12" "1994" "1995-01-23" "1995" 1 "L51909WB1983PLC035874" "Removed from ISEC2" "2022-07-23 13:18:37" 0
12150008.00 "Reliance Industries Ltd." "Reliance Inds." 230 "Refineries" 10002 "Ambani Group" "1973-05-08" "1973" "1975-06-28" "1975" 1 "L17110MH1973PLC019786" NULL "2019-03-21 11:53:12" 0
12140008.00 "Reliance Petroleum Ltd.(Old)" "ReliancePetrole(Old)" 230 "Refineries" 10002 "Ambani Group" "1991-09-03" "1991" "1993-09-23" "1993" 1 NULL "Merged" "2017-09-08 19:16:32" 1
15210313.00 "East West Pipeline Ltd." "East West Pipeline L" 521 "Infrastructure - General" 10002 "Ambani Group" "1999-06-04" "1999" "" NULL 1 "U60300MH1999PTC326443" NULL "2020-08-04 01:13:32" 0
17200005.00 "Data Infrastructure Trust" "Data Infrastructure" 720 "Investment Trusts" 10002 "Ambani Group" "2019-03-19" "2019" "" "" 1 "" NULL "2022-02-15 10:21:19" 0
12300011.00 "Reliance Petroleum Ltd.(Merged)" "Reliance Petroleum L" 230 "Refineries" 10002 "Ambani Group" "2005-10-24" "2005" "2006-04-13" "2006" 1 "L23209GJ1993PLC018863" "Merged" "2017-01-10 16:14:14" 0
12130028.00 "Indian Petrochemicals Corporation Ltd." "Indian Petrochem" 213 "Petrochem - Polymers" 10002 "Ambani Group" "1969-12-31" "1969" "" NULL 1 "L23200GJ1969PLC001569" "Merged" "2017-09-13 17:23:00" 0
15200244.00 "Reliance Jio Infocomm Ltd." "Reliance Jio Infocom" 520 "Telecom Services" 10002 "Ambani Group" "" NULL "" NULL 1 "U72900MH2007PLC234712" NULL "2017-05-26 17:21:04" 0
17027498.00 "Reliance Retail Ltd." "Reliance Retail" 702 "Miscellaneous" 10002 "Ambani Group" "1999-06-29" "1999" "" NULL 1 "U01100MH1999PLC120563" NULL "2016-03-10 14:37:09" 0
17020045.00 "Reliance Industrial InfraStructure Ltd." "Reliance Ind.Inf" 353 "Project Consultancy/Turnkey" 10002 "Ambani Group" "1988-09-29" "1988" "" NULL 1 "L60300MH1988PLC049019" NULL "2016-03-10 14:34:50" 0
12140007.00 "Reliance Petrochemicals Ltd." "Reliance Petro." 214 "Petrochem - Others" 10002 "Ambani Group" "" NULL "" NULL 1 NULL NULL "2016-03-10 11:49:10" 0
17200015.00 "Digital Fibre Infrastructure Trust" "Digital Fibre Infra" 720 "Investment Trusts" 10002 "Ambani Group" "2019-03-20" "2019" "" "" 1 "" NULL "2023-03-31 07:37:35" 0
12150008.04 "Vimal Fabrics Ltd." "Vimal Fabrics Ltd." 603 "Textiles - Spinning - Cotton Blended" 10002 "Ambani Group" "" NULL "" NULL 1 NULL NULL "2016-03-10 11:49:05" 0
11510008.00 "Ambuja Cement Eastern Ltd." "Ambuja Cement Ea" 151 "Cement" 10003 "Ambuja Group" "1982-06-17" "1982" "" "1986" 1 "U26942CT1985PLC003076" "Merged" "2017-09-13 18:46:23" 0