将文件拖动至此

SQL 上传 ( 0 ) x -

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





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

浏览模式

自定义浏览模式。

文档 仅使用图标、文字或都使用。
文档 仅使用图标、文字或都使用。
文档 设置是否给用户显示一个 "显示所有 (记录)" 的按钮。
文档 浏览结果集时显示的行数。若结果集总行数超过该值,将会显示 "上一页" 和 "下一页" 的链接。
文档 SMART - 即对 TIME、DATE、DATETIME 和 TIMESTAMP 类型的字段递减排序,其它字段递增。
文档 高亮鼠标指针所在的行。
文档 高亮选中的行。
文档
文档
文档 每 X 单元格重复表头,要禁止此功能请设为 0
文档 浏览非数字字段时最多显示的字数。
文档 这些是编辑、复制和删除链接。
文档 缺少唯一键时是否显示行链接。
文档 默认用主键为表排序。
文档 当浏览表时使用上次的排序方式。
文档 显示选项
正在显示第 0 - 24 行 (共 20986 行, 查询花费 0.0144 秒。) [FirstTradedPrice: 0.00... - 0.00...]
SELECT * FROM `ListingMaster` ORDER BY `FirstTradedPrice`  ASC 
完整内容 SecurityCodeExchangeCodeExchangeGroupScripCode1GivenByExchangeScripCode2GivenByExchangeDateOfListingDateOfDeListingDateOfReEnlistingFirstTradedDateFirstTradedPrice 递增 递减 1LastTradedDateLastTradedPriceFiftyTwoWeekHighFiftyTwoWeekLowHighdateLowdateCircuitLimitReasonForModificationDeleteFlagModifiedDate
SecurityCode 0 ExchangeGroup ScripCode1GivenByExchange ScripCode2GivenByExchange DateOfListing DateOfDeListing DateOfReEnlisting FirstTradedDate 0.00 LastTradedDate 0.00 0.00 0.00 Highdate Lowdate 0 ReasonForModification 0 ModifiedDate
010520003.14052004002 47 "F" 936402 9MMFSL22 "2019-01-22" "" "" "2019-01-22" 0.00 "2022-03-16" 1063.00 1220.00 1005.00 "2021-12-29" "2021-06-22" 0 "NCD Listing" 0 "2023-03-15 18:50:00"
010520003.14052004004 47 "F" 936406 91MMFSL24 "2019-01-22" "" "" "2019-01-22" 0.00 "2022-09-05" 1184.40 1184.40 836.80 "2022-09-05" "2022-09-05" 0 "NCD Listing" 0 "2022-09-05 19:14:00"
010520003.14052004006 47 "F" 936410 92MMFSL27 "2019-01-22" "" "" "2019-01-22" 0.00 "2023-07-03" 1140.00 1180.50 1015.00 "2023-02-13" "2023-03-27" 0 "NCD Listing" 0 "2023-07-03 18:29:00"
010520003.14156004001 47 "F" 935730 834MMFSL21 "2016-06-09" "" "" "2016-06-09" 0.00 "2016-06-09" 1000.00 0.00 0.00 "" "" 0 "Fresh entry" 0 "2016-06-16 00:00:00"
010520003.14156004003 47 "F" 935734 844MMFSL23 "2016-06-09" "" "" "2016-06-09" 0.00 "2023-01-10" 1007.00 1007.00 1007.00 "2023-01-10" "2023-01-10" 0 "Fresh entry" 0 "2023-01-10 20:06:00"
010520003.14156004004 47 "F" 935736 853MMFSL23 "2016-06-09" "" "" "2016-06-09" 0.00 "2023-01-10" 990.13 1000.12 990.13 "2022-05-02" "2023-01-10" 0 "Fresh entry" 0 "2023-07-07 22:23:00"
010520003.14156004005 47 "F" 935738 853MMFSL26 "2016-06-09" "" "" "2016-06-09" 0.00 "2022-08-03" 1000.00 1000.00 1000.00 "2022-08-03" "2022-08-03" 0 "Fresh entry" 0 "2022-08-03 19:58:00"
010520003.14156004007 47 "F" 935742 86MMFSL21 "2016-06-09" "" "" "2016-06-09" 0.00 "2016-06-09" 1000.00 0.00 0.00 "" "" 0 "Fresh entry" 0 "2016-06-20 00:00:00"
010520003.14156004009 47 "F" 935746 87MMFSL23 "2016-06-09" "" "" "2016-06-09" 0.00 "2021-02-10" 985.80 1194.40 985.80 "2021-02-10" "2021-02-10" 0 "Fresh entry" 0 "2021-02-10 19:35:00"
010520003.14156004011 47 "F" 935750 88MMFSL26 "2016-06-09" "" "" "2016-06-09" 0.00 "2022-12-15" 959.40 1313.80 959.40 "2022-12-15" "2022-12-15" 0 "Fresh entry" 0 "2022-12-15 19:28:00"
010520003.14156004014 47 "F" 935756 MMFSL23 "2016-06-09" "" "" "2016-06-09" 0.00 "2023-02-13" 1750.00 1800.00 1645.00 "2022-06-30" "2022-03-23" 0 "Fresh entry" 0 "2023-07-07 22:23:00"
010520003.14156004015 47 "F" 935758 MMFSL26 "2016-06-09" "" "" "2016-06-09" 0.00 "2020-03-11" 1248.00 1694.00 1102.00 "2019-03-13" "2019-03-26" 0 "Fresh entry" 0 "2021-03-10 19:25:00"
010520003.14156004017 47 "F" 936038 775MMFSL24 "2017-07-27" "" "" "2017-07-27" 0.00 "2017-07-27" 1000.00 0.00 0.00 "" "" 0 "New entry" 0 "2017-07-28 20:49:00"
010520003.14156004018 47 "F" 936040 785MMFSL24 "2017-07-27" "" "" "2017-07-27" 0.00 "2023-06-28" 1028.00 1060.00 975.20 "2023-02-07" "2023-06-27" 0 "New entry" 0 "2023-06-28 18:46:00"
010520003.14156004019 47 "F" 936042 790MMFSL27 "2017-07-27" "" "" "2017-07-27" 0.00 "2021-02-17" 892.40 1199.80 892.40 "2021-02-17" "2021-02-17" 0 "New entry" 0 "2021-02-17 18:48:00"
010520003.14156004021 47 "F" 936046 795MMFSL32 "2017-07-27" "" "" "2017-07-27" 0.00 "2021-03-22" 893.20 1418.00 886.00 "2021-02-23" "2021-03-17" 0 "New entry" 0 "2022-03-21 20:28:00"
010520003.14156004023 47 "F" 936414 935MMFSL29 "2019-01-18" "" "" "2019-01-18" 0.00 "2022-08-05" 840.80 1187.40 840.80 "2022-08-05" "2022-08-05" 0 "NCD Listing" 0 "2022-08-05 19:32:00"
010560001.00111004001 47 "R" 750680 BGEAR-RE "2021-11-22" "" "" "2021-11-18" 0.00 "2021-12-02" 103.65 190.00 18.10 "2021-12-02" "2021-11-23" 0 "RE Listing" 0 "2022-12-01 19:40:00"
010620033.00005004001 47 "B" 543930 URAVI "2023-07-05" "" "" "2023-07-04" 0.00 "2023-07-07" 282.80 294.55 262.70 "2023-07-05" "2023-07-06" 0 "Migrated to BSE & NSE MB wef 05/07/2023" 0 "2023-07-07 18:29:00"
010670063.00111004001 47 "R" 750688 SHIVAM-RE "2021-12-31" "" "" "2021-12-29" 0.00 "2022-01-21" 19.80 96.35 8.55 "2022-01-10" "2021-12-31" 0 "RE Listing" 0 "2023-01-20 20:05:00"
010670285.00005004001 47 "IP" 780020 PRITIKAST "" "2017-02-21" "" "2015-04-28" 0.00 "2015-04-28" 10.00 0.00 0.00 "" "" 10 "De-listed as per SEBI De-listing guidelines" 0 "2017-02-20 21:29:00"
010760029.00111004001 47 "R" 750667 PRAXIS-RE "2021-09-21" "" "" "2021-09-16" 0.00 "2021-09-30" 15.40 33.00 11.50 "2021-09-24" "2021-09-30" 0 "RE Listing" 0 "2022-09-29 20:23:00"
010760029.00111004002 47 "R" 750789 PRAXIS-RE1 "2023-06-06" "" "" "2023-06-05" 0.00 "2023-06-09" 0.83 1.64 0.76 "2023-06-08" "2023-06-09" 0 "RE Listing" 0 "2023-06-09 18:53:00"
011040061.00111004001 47 "R" 750694 JOONKT-RE "2022-02-04" "2022-02-15" "" "2022-01-28" 0.00 "2022-02-14" 30.00 89.60 29.70 "2022-02-04" "2022-02-14" 0 "Suspended" 0 "2023-02-13 20:08:00"