将文件拖动至此

SQL 上传 ( 0 ) x -

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





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

浏览模式

自定义浏览模式。

文档 仅使用图标、文字或都使用。
文档 仅使用图标、文字或都使用。
文档 设置是否给用户显示一个 "显示所有 (记录)" 的按钮。
文档 浏览结果集时显示的行数。若结果集总行数超过该值,将会显示 "上一页" 和 "下一页" 的链接。
文档 SMART - 即对 TIME、DATE、DATETIME 和 TIMESTAMP 类型的字段递减排序,其它字段递增。
文档 高亮鼠标指针所在的行。
文档 高亮选中的行。
文档
文档
文档 每 X 单元格重复表头,要禁止此功能请设为 0
文档 浏览非数字字段时最多显示的字数。
文档 这些是编辑、复制和删除链接。
文档 缺少唯一键时是否显示行链接。
文档 默认用主键为表排序。
文档 当浏览表时使用上次的排序方式。
文档 显示选项
正在显示第 0 - 24 行 (共 5255 行, 查询花费 0.0071 秒。) [IncorporationDate: ""... - "1907-07-30"...]
SELECT * FROM `BackgroundInfo` ORDER BY `IncorporationDate`  ASC 
完整内容 CompanyCodeParentCompanyCodeCompanyNameShortCompanyNameTickerNamePersonDescriptionPersonNameExecutiveDescriptionExecutiveNameExchangeCodeExchangeNameExchangeGroupSourcetypeIncorporationDate 递增 递减 1FirstPublicIssueDateAuditeddateFaceValueMarketlotIndustryCodeIndustryNameBusinessGroupCodeBusinessGroupNameMajorSectorLatestFinYearForemostFinYearLatestHalfYearForemostHalfYearLatestQtrYearForemostQtrYearModifiedDate
14010039.00 0.00 "Haryana Financial Corporation" "Haryana Financia" "HarynFinCorp" "Mr." "Rajesh Khullar" "Ms." "ShaPujarma" "530927" "BSE" "ZY" "A" "" "1995-05-18" "2022-09-27" 10.00 100 404 "Finance - Term Lending Institutions" 10120 "Public Sector" 1 "2203" "9403" "2209" "9503" "2212" "9806" "2023-07-08 20:08:52"
11040005.00 0.00 "Bombay Burmah Trading Corporation Ltd." "Bombay Burmah" "BbayBurmahTr" "Mr." "Nusli N Wadia" "Mr." "Sanjay Kumar Chowdhary" "501425" "BSE" "A" "A" "1863-04-09" "" "" 2.00 1 104 "Plantations - Tea & Coffee" 10157 "Wadia Group" 1 "2203" "8903" "2303" "8909" "2303" "9806" "2023-07-08 20:08:52"
16010007.00 0.00 "Peninsula Land Ltd." "Peninsula Land L" "Peninsula La" "Mr." "Rajeev A Piramal" "Ms." "Sonal Rathod" "503031" "BSE" "B" "A" "1871-08-10" "1943-06-01" "" 2.00 1 162 "Construction & Contracting" 10115 "Piramal Ashok Group" 1 "2203" "8906" "2303" "8906" "2303" "9709" "2023-07-08 20:08:52"
11040067.00 0.00 "Longview Tea Company Ltd." "Longview Tea" "LongviewTeaC" "Mrs." "Nikita Puria" "526568" "BSE" "XT" "A" "1879-01-16" "" "" 10.00 1 104 "Plantations - Tea & Coffee" 10514 "Not Applicable" 1 "2303" "9312" "2303" "9412" "2303" "9806" "2023-07-08 20:08:52"
16010003.00 0.00 "Bombay Dyeing & Manufacturing Company Ltd." "Bombay Dyeing" "BombayDyeing" "Mr." "Nusli N Wadia" "Mr." "Sanjive Arora" "500020" "BSE" "A" "A" "1879-08-23" "" "" 2.00 1 602 "Textiles - Processing/Texturising" 10157 "Wadia Group" 1 "2203" "8903" "2303" "8909" "2303" "9806" "2023-07-08 20:08:52"
17010004.00 0.00 "DCM Ltd." "DCM Ltd." "DCM" "Mr." "Bipin Maira" "Mr." "Yadvinder Goyal" "502820" "BSE" "B" "A" "1889-03-26" "" "" 10.00 1 356 "Castings/Foundry" 10037 "DCM Group" 1 "2203" "8903" "2303" "8903" "2303" "9706" "2023-07-08 20:08:52"
11040100.00 0.00 "Tyroon Tea Company Ltd." "Tyroon Tea Compa" "Tyroon Tea" "Mr." "K C Mishra" "526945" "BSE" "X" "A" "1890-06-21" "1995-02-15" "" 10.00 1 104 "Plantations - Tea & Coffee" 10514 "Not Applicable" 1 "2203" "9403" "2303" "9309" "2303" "9809" "2023-07-08 20:08:52"
17010016.00 0.00 "Standard Industries Ltd." "Standard Indust" "Std Inds" "Mr." "Pradeep R Mafatlal" "Mrs." "Tanaz B Panthaki" "530017" "BSE" "T" "A" "1892-01-25" "" "" 5.00 1 209 "Chemicals - Inorganic - Caustic Soda/Soda Ash" 10095 "Mafatlal (RM) Group" 1 "2303" "8903" "2303" "8909" "2303" "9706" "2023-07-08 20:08:52"
11040023.00 0.00 "The Grob Tea Company Ltd." "The Grob Tea Company" "The Grob Tea" "Mr." "P K Agarwal" "Mrs." "Kritika Mohata" "BSE" "A" "1895-01-07" "" "" 10.00 1 104 "Plantations - Tea & Coffee" 10514 "Not Applicable" 1 "2203" "8903" "2303" "9109" "2303" "9812" "2023-07-08 20:08:52"
17010003.00 0.00 "Century Textiles & Industries Ltd." "Century Textiles" "Century Text" "Mr." "Kumar Mangalam Birla" "Mr." "Atul K Kedia" "500040" "BSE" "A" "A" "1897-10-20" "" "" 10.00 1 649 "Textiles - General" 10016 "BK Birla Group" 1 "2303" "8812" "2303" "8909" "2303" "9806" "2023-07-08 20:08:52"
17020067.00 0.00 "Cheviot Company Ltd." "Cheviot Co Ltd" "Cheviot Co" "Mr." "Aditya Banerjee" "526817" "BSE" "B" "A" "1897-12-27" "1995-10-24" "" 10.00 1 463 "Jute/Jute Yarn/Jute Products" 10514 "Not Applicable" 1 "2203" "9203" "2303" "9303" "2303" "9806" "2023-07-08 20:08:52"
11040061.00 0.00 "Shri Vasuprada Plantations Ltd." "Shri Vasuprada Plant" "Joonktol.Tea" "Mr." "Sharad Bagree" "538092" "BSE" "X" "A" "1900-08-07" "" "" 10.00 1 104 "Plantations - Tea & Coffee" 10514 "Not Applicable" 1 "2203" "9203" "2303" "0703" "2303" "0703" "2023-07-08 20:08:52"
17010005.00 0.00 "Empire Industries Ltd." "Empire Inds." "Empire Inds" "Mr." "S C Malhotra" "Mr." "Suhas Chandra Nanda" "509525" "BSE" "X" "A" "1900-10-17" "" "" 10.00 1 458 "Glass & Glass Products" 10043 "Empire Group" 1 "2203" "8812" "2303" "8909" "2303" "9706" "2023-07-08 20:08:52"
14090067.00 0.00 "Pilani Investment and Industries Corporation Ltd.... "Pilani Investmen" "Pilani Inv" "Mr." "R S Kashyap" "539883" "BSE" "B" "A" "1901-01-01" "" "" 10.00 1 409 "Finance & Investments" 10016 "BK Birla Group" 1 "2203" "9403" "2303" "9603" "2303" "9812" "2023-07-08 20:08:52"
16560007.00 0.00 "Indian Hotels Company Ltd." "Indian Hotels Co" "IndianHotels" "Mr." "Puneet Chhatwal" "500850" "BSE" "A" "A" "1902-04-01" "" "" 1.00 1 662 "Hotels, Resorts & Restaurants" 10141 "Tata Group" 1 "2303" "8903" "2303" "8909" "2303" "9706" "2023-07-08 20:08:52"
11580008.00 0.00 "Shalimar Paints Ltd." "Shalimar Paints" "ShalimrPaint" "Mr." "Ashok Kumar Gupta" "Ms." "Shikha Rastogi" "509874" "BSE" "B" "A" "1902-12-16" "" "" 2.00 1 158 "Paints/Varnishes" 10514 "Not Applicable" 1 "2203" "8903" "2303" "8909" "2303" "9809" "2023-07-08 20:08:52"
14560013.00 0.00 "Hindoostan Mills Ltd." "Hindoostan Mills" "Sirdar Carbo" "Mr." "Chandrahas Thackersey" "Mr." "Kaushik Narottamdas Kapasi" "509895" "BSE" "X" "A" "1904-05-12" "" "" 10.00 1 649 "Textiles - General" 10514 "Not Applicable" 1 "2203" "9203" "2303" "9303" "2303" "9706" "2023-07-08 20:08:52"
14030077.00 0.00 "City Union Bank Ltd." "City Union Bank" "CityUnionBnk" "Dr." "N Kamakodi" "Mr." "V Ramesh" "532210" "BSE" "A" "A" "1904-10-31" "1998-06-22" "2022-05-27" 1.00 1 403 "Finance - Banks - Private Sector" 10514 "Not Applicable" 2 "2203" "9303" "2303" "9703" "2303" "9712" "2023-07-08 20:08:52"
16490110.00 0.00 "Phoenix Mills Ltd." "Phoenix Mills" "Phoenix Mill" "Mr." "Atul Ruia" "Mr." "Gajendra Mewara" "503100" "BSE" "A" "A" "1905-01-27" "" "" 2.00 1 162 "Construction & Contracting" 10217 "Phoenix Group" 1 "2203" "8903" "2303" "9209" "2303" "9709" "2023-07-08 20:08:52"
11060008.00 0.00 "Rasoi Ltd." "Rasoi Ltd." "Mr." "Raghu Nandan Mody" "Mr." "Naresh Patangi" "BSE" "A" "1905-02-03" "" "2018-05-22" 0.00 0 112 "Edible Oils & Solvent Extraction" 10122 "Rasoi Group" 1 "1803" "8903" "1809" "8903" "1812" "9706" "2023-07-08 20:08:52"
14030061.00 0.00 "Canara Bank" "Canara Bank" "Canara Bank" "Mr." "K Satyanarayana Raju" "Mr." "Vinay Mohta" "532483" "BSE" "A" "A" "1906-07-01" "" "2023-05-08" 10.00 1 410 "Finance - Banks - Public Sector" 10120 "Public Sector" 2 "2303" "9203" "2303" "9403" "2303" "0006" "2023-07-08 20:08:52"
14030011.00 0.00 "Bank of India" "Bank of India" "BankofIndia" "Mr." "Rajneesh Karnatak" "Mr." "Rajesh V Upadhya" "532149" "BSE" "A" "A" "1906-09-07" "1996-07-01" "2023-05-06" 10.00 1 410 "Finance - Banks - Public Sector" 10120 "Public Sector" 2 "2303" "9203" "2303" "9403" "2303" "9706" "2023-07-08 20:08:52"
14030019.00 0.00 "Indian Bank" "Indian Bank" "Indian Bank" "Mr." "S L Jain" "Mr." "Dina Nath Kumar" "532814" "BSE" "A" "A" "1907-03-05" "" "2023-05-08" 10.00 1 410 "Finance - Banks - Public Sector" 10120 "Public Sector" 2 "2303" "9203" "2303" "9403" "2303" "0412" "2023-07-08 20:08:52"
13520029.00 0.00 "Jost's Engineering Company Ltd." "Jost's Engg." "Josts Engg" "Mr." "Jai Prakash Agarwal" "Ms." "Prajakta Patil" "505750" "BSE" "XT" "A" "1907-05-09" "" "" 2.00 1 351 "Engineering - Heavy" 10514 "Not Applicable" 1 "2203" "8903" "2303" "8909" "2303" "9706" "2023-07-08 20:08:52"
12540002.00 0.00 "Alembic Ltd." "Alembic Ltd." "Alembic" "Mrs." "Malika Amin" "Mr." "Drigesh Mittal" "506235" "BSE" "B" "A" "1907-07-30" "" "" 2.00 1 254 "Pharmaceuticals" 11176 "Alembic Group" 1 "2203" "8903" "2303" "8909" "2303" "9803" "2023-07-08 20:08:52"