• 表收藏夹为空。

将文件拖动至此

SQL 上传 ( 0 ) x -

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





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

浏览模式

自定义浏览模式。

文档 仅使用图标、文字或都使用。
文档 仅使用图标、文字或都使用。
文档 设置是否给用户显示一个 "显示所有 (记录)" 的按钮。
文档 浏览结果集时显示的行数。若结果集总行数超过该值，将会显示 "上一页" 和 "下一页" 的链接。
文档 SMART - 即对 TIME、DATE、DATETIME 和 TIMESTAMP 类型的字段递减排序，其它字段递增。
文档 高亮鼠标指针所在的行。
文档 高亮选中的行。
文档
文档
文档 每 X 单元格重复表头，要禁止此功能请设为 0。
文档 浏览非数字字段时最多显示的字数。
文档 这些是编辑、复制和删除链接。
文档 缺少唯一键时是否显示行链接。
文档 默认用主键为表排序。
文档 当浏览表时使用上次的排序方式。
文档 显示选项
当前所选内容没有包含唯一字段。单元格编辑、复选框、编辑、复制和删除无法正常使用。文档
正在显示第 0 - 24 行 (共 460 行, 查询花费 0.0040 秒。) [ord_status: 52... - 56...]
SELECT * FROM `AncOrderHistoryMfd` ORDER BY `ord_status` ASC
[编辑内嵌] [ 编辑 ] [ 解析 SQL ] [ 创建 PHP 代码 ] [ 刷新]
|
|
|
|
行数：
过滤行:
noren_ord_numnoren_time_stampnoren_nsecserefnoren_kid_idord_status 递增 递减 1report_typeacct_iduser_idord_srctrading_symbolexch_segtokentrans_typeprice_typeproductord_durationbroker_idregionfamily_idcust_firmpartic_idpan_numqty_to_fillred_qtyprice_to_fillred_pricerej_reasonrej_bynoren_org_time_stampnoren_org_nsecsdisc_qtyexch_user_idord_remarksprice_precisionqty_precisionmkt_indsymbol_nameexchangesegmenttrd_symbolinstrument_nameoption_typetick_sizespread_trading_symbol_leg_1spread_trading_symbol_leg_2hl_min_pricehl_max_pricebo_min_pricebo_max_pricecon_prod_idsip_min_amtsip_max_amtsip_inc_amtsip_min_instsip_max_instsip_val_detgui_statusred_checkred_super_userexch_seg_acct_idrej_qtyrej_ord_srcrej_price_typeuser_privilegepurchse_typedp_transkyc_status
26060290000016 1780390599 736754578 26060200000031 2 52 52 NAMITH NAMITH TT 007-DP BSTAR 201 B LMT C DAY KSPL KSPL KSPL C _gWJ9NNmIKQ5WDU08d8jFRiOFCqtRtkRMGnw= 13974 13974 10000000 10000000 CXL CONF: Your Request to Cancel Order No16513175 ... EXCH 1780390598 489853120 0 1320001 4 3 1 SBIMutualFund_MF BSE MFSS 007-DP 007DP 007D 10000000 NULL NULL 100000 1 1000 0 EQUITY 0 0 0 0 0 NULL 52 1 0 NAMITH 0 NULL NULL 5 FRESH CDSL 1
26060290000016 1780390598 490855554 26060200000031 2 54 54 NAMITH NAMITH TT 007-DP BSTAR 201 B LMT C DAY KSPL KSPL KSPL C _gWJ9NNmIKQ5WDU08d8jFRiOFCqtRtkRMGnw= 13974 13974 10000000 10000000 NULL NULL 1780390598 489853120 0 1320001 4 3 1 SBIMutualFund_MF BSE MFSS 007-DP 007DP 007D 10000000 NULL NULL 100000 1 1000 0 EQUITY 0 0 0 0 0 NULL 65 1 0 NAMITH 0 NULL NULL 5 FRESH CDSL 1
26051390000001 1778658814 945519889 0 1 56 56 DHANUSHINVES DHANUSHINVES MOB 02G BSTAR 72 S LMT C DAY KSPL KARKALA KSPL C _gWJ9NNmIKQ5WDU08d8jFRiOFCqtRtkRMGnw= 0 0 0 0 ORA: client DHANUSHINVES bank details mandatory fo... ORA 0 0 0 NULL NULL 4 3 1 BirlaSunLifeMutualFund_MF BSE MFSS 02G 02G 02G 5000000 NULL NULL 1 1 0 0 ELSS 0 0 0 0 0 NULL 56 0 0 0 NULL NULL 5 ALL P 1
26051390000002 1778658859 942937868 0 1 56 56 DHANUSHINVES DHANUSHINVES MOB UASELSRP-DP BSTAR 51744 S LMT C DAY KSPL KARKALA KSPL C _gWJ9NNmIKQ5WDU08d8jFRiOFCqtRtkRMGnw= 500000 0 50000000 0 ORA: client DHANUSHINVES bank details mandatory fo... ORA 0 0 0 NULL NULL 4 3 1 UNIONMUTUALFUND_MF_SIF BSE MFSS UASELSRP-DP ELSRP UKS 1000000000 NULL NULL 1 1 1000 0 EQUITY 0 0 0 0 0 NULL 56 0 0 0 NULL NULL 5 QTY P 1
26051390000003 1778658879 622780943 0 1 56 56 DHANUSHINVES DHANUSHINVES MOB SBIPSU-GR BSTAR 914 S LMT C DAY KSPL KARKALA KSPL C _gWJ9NNmIKQ5WDU08d8jFRiOFCqtRtkRMGnw= 0 0 0 0 ORA: client DHANUSHINVES bank details mandatory fo... ORA 0 0 0 NULL NULL 4 3 1 SBIMutualFund_MF BSE MFSS SBIPSU-GR 192G 192G 10000000 NULL NULL 1000 1 500 0 EQUITY 0 0 0 0 0 NULL 56 0 0 0 NULL NULL 5 ALL P 1
26051390000004 1778659261 772387927 0 1 56 56 DHANUSHINVES DHANUSHINVES MOB SBIPSU-GR BSTAR 914 S LMT C DAY KSPL KARKALA KSPL C _gWJ9NNmIKQ5WDU08d8jFRiOFCqtRtkRMGnw= 1500000 0 521815500 0 ORA: client DHANUSHINVES bank details mandatory fo... ORA 0 0 0 NULL NULL 4 3 1 SBIMutualFund_MF BSE MFSS SBIPSU-GR 192G 192G 10000000 NULL NULL 1000 1 500 0 EQUITY 0 0 0 0 0 NULL 56 0 0 0 NULL NULL 5 QTY P 1
26051390000005 1778659369 767938789 0 1 56 56 DHANUSHINVES DHANUSHINVES MOB SBIPSU-GR BSTAR 914 S LMT C DAY KSPL KARKALA KSPL C _gWJ9NNmIKQ5WDU08d8jFRiOFCqtRtkRMGnw= 0 0 0 0 ORA: client DHANUSHINVES bank details mandatory fo... ORA 0 0 0 NULL NULL 4 3 1 SBIMutualFund_MF BSE MFSS SBIPSU-GR 192G 192G 10000000 NULL NULL 1000 1 500 0 EQUITY 0 0 0 0 0 NULL 56 0 0 0 NULL NULL 5 ALL P 1
26051390000006 1778659761 192179674 0 1 56 56 DHANUSHINVES DHANUSHINVES WEB SBIPSU-GR BSTAR 914 S LMT C DAY KSPL KARKALA KSPL C _gWJ9NNmIKQ5WDU08d8jFRiOFCqtRtkRMGnw= 1500000 0 521815500 0 ORA: client DHANUSHINVES bank details mandatory fo... ORA 0 0 0 NULL NULL 4 3 1 SBIMutualFund_MF BSE MFSS SBIPSU-GR 192G 192G 10000000 NULL NULL 1000 1 500 0 EQUITY 0 0 0 0 0 NULL 56 0 0 0 NULL NULL 5 QTY NSDL 1
26051390000007 1778659801 633991252 0 1 56 56 DHANUSHINVES DHANUSHINVES WEB SBIPSU-GR BSTAR 914 S LMT C DAY KSPL KARKALA KSPL C _gWJ9NNmIKQ5WDU08d8jFRiOFCqtRtkRMGnw= 0 0 0 0 ORA: client DHANUSHINVES bank details mandatory fo... ORA 0 0 0 NULL NULL 4 3 1 SBIMutualFund_MF BSE MFSS SBIPSU-GR 192G 192G 10000000 NULL NULL 1000 1 500 0 EQUITY 0 0 0 0 0 NULL 56 0 0 0 NULL NULL 5 ALL NSDL 1
26051390000008 1778660362 476624272 0 1 56 56 DHANUSHINVES DHANUSHINVES MOB 02G BSTAR 72 S LMT C DAY KSPL KARKALA KSPL C _gWJ9NNmIKQ5WDU08d8jFRiOFCqtRtkRMGnw= 2000000 0 1174400000 0 ORA: client DHANUSHINVES bank details mandatory fo... ORA 0 0 0 NULL NULL 4 3 1 BirlaSunLifeMutualFund_MF BSE MFSS 02G 02G 02G 5000000 NULL NULL 1 1 0 0 ELSS 0 0 0 0 0 NULL 56 0 0 0 NULL NULL 5 QTY P 1
26051590000001 1778819621 46151349 26051500000001 1 56 56 ANANYARAMA3 ANANYARAMA3 WEB HDFCSTOG-GR BSTAR 1100 B LMT C DAY KSPL Mangaluru KSPL C _gWJ9NNn4WX4mDcBgjbAMUSPheCuTiXpmwk0= 29922 29922 10000000 10000000 SAF:Yel is down YEL 1778819621 36544234 0 1320001 NULL 4 3 1 HDFCMutualFund_MF BSE MFSS HDFCSTOG-GR STOG STOG 1000000 NULL NULL 1 1 100 0 DEBT 0 0 0 0 0 NULL 56 1 0 NULL 29922 WEB LMT 5 FRESH CDSL 1
26051590000002 1778819707 837058586 26051500000002 1 56 56 ANANYARAMA3 ANANYARAMA3 WEB HDFCSTOG-GR BSTAR 1100 B LMT C DAY KSPL Mangaluru KSPL C _gWJ9NNn4WX4mDcBgjbAMUSPheCuTiXpmwk0= 29922 29922 10000000 10000000 SAF:Yel is down YEL 1778819707 834633803 0 1320001 NULL 4 3 1 HDFCMutualFund_MF BSE MFSS HDFCSTOG-GR STOG STOG 1000000 NULL NULL 1 1 100 0 DEBT 0 0 0 0 0 NULL 56 1 0 NULL 29922 WEB LMT 5 FRESH CDSL 1
26051890000001 1779098427 944783258 26051800000001 1 56 56 ANANYARAMA2 ANANYARAMA2 WEB HDFC01D-DR BSTAR 1551 B LMT C DAY KSPL MANGLORE KSPL C _gWJ9NNn4WX4mDcBgjbAMUSPheCuTiXpmwk0= 1429 1429 1000000 1000000 SAF:Yel is down YEL 1779098427 889019211 0 1320001 NULL 4 3 1 HDFCMutualFund_MF BSE MFSS HDFC01D-DR 01D 01D 1000000 NULL NULL 1 1 100 0 EQUITY 0 0 0 0 0 NULL 56 1 0 NAMITH 1429 WEB LMT 5 FRESH CDSL 1
26052790000001 1779872434 575499849 0 1 56 56 SARTHAK SARTHAK MOB DS657-GR BSTAR 45374 S LMT C DAY KSPL MANGALORE KSPL C _gWJ9NNmIKQ5WfRM9RA0dNLbCYwfTlTsS2qI= 950000000 0 113259000000 0 ORA: client SARTHAK bank details mandatory for red... ORA 0 0 0 12345 NULL 4 3 1 DSP_MF BSE MFSS DS657-GR 657 657 1000000 NULL NULL 10 1 0 0 EQUITY 0 0 0 0 0 NULL 56 0 0 12018970 0 NULL NULL 5 QTY P 1
26052890000001 1779949604 743501570 0 1 56 56 DHANUSHINVES DHANUSHINVES MOB UASELSRP-DP BSTAR 51744 S LMT C DAY KSPL KARKALA KSPL C _gWJ9NNmIKQ5WDU08d8jFRiOFCqtRtkRMGnw= 500000 0 50000000 0 ORA: client DHANUSHINVES bank details mandatory fo... ORA 0 0 0 NULL NULL 4 3 0 UNIONMUTUALFUND_MF_SIF BSE MFSS UASELSRP-DP ELSRP UKS 100000000 NULL NULL 1 1 1000 0 EQUITY 0 0 0 0 0 NULL 56 0 0 0 NULL NULL 5 QTY P 1
26052890000002 1779949901 980359822 0 1 56 56 DHANUSHINVES DHANUSHINVES MOB UASELSDP-DP BSTAR 51747 S LMT C DAY KSPL KARKALA KSPL C _gWJ9NNmIKQ5WDU08d8jFRiOFCqtRtkRMGnw= 1000000 0 100000000 0 ORA: client DHANUSHINVES bank details mandatory fo... ORA 0 0 0 NULL NULL 4 3 0 UNIONMUTUALFUND_MF_SIF BSE MFSS UASELSDP-DP ELSDP UKS 100000000 NULL NULL 1 1 1000 0 EQUITY 0 0 0 0 0 NULL 56 0 0 0 NULL NULL 5 QTY P 1
26052890000003 1779951307 472321697 0 1 56 56 DHANUSHINVES DHANUSHINVES MOB UASELSRP-DP BSTAR 51744 S LMT C DAY KSPL KARKALA KSPL C _gWJ9NNmIKQ5WDU08d8jFRiOFCqtRtkRMGnw= 500000 0 50000000 0 ORA: client DHANUSHINVES bank details mandatory fo... ORA 0 0 0 NULL NULL 4 3 0 UNIONMUTUALFUND_MF_SIF BSE MFSS UASELSRP-DP ELSRP UKS 100000000 NULL NULL 1 1 1000 0 EQUITY 0 0 0 0 0 NULL 56 0 0 0 NULL NULL 5 QTY P 1
26052890000004 1779953342 226396748 0 1 56 56 DHANUSHINVES DHANUSHINVES MOB 02G BSTAR 72 S LMT C DAY KSPL KARKALA KSPL C _gWJ9NNmIKQ5WDU08d8jFRiOFCqtRtkRMGnw= 2000 0 1208400 0 ORA: client DHANUSHINVES bank details mandatory fo... ORA 0 0 0 NULL NULL 4 3 1 BirlaSunLifeMutualFund_MF BSE MFSS 02G 02G 02G 5000000 NULL NULL 1 1 0 0 ELSS 0 0 0 0 0 NULL 56 0 0 0 NULL NULL 5 QTY P 1
26052890000005 1779960010 653699329 0 1 56 56 DHANUSHINVES DHANUSHINVES MOB SBIPSU-GR BSTAR 914 S LMT C DAY KSPL KARKALA KSPL C _gWJ9NNmIKQ5WDU08d8jFRiOFCqtRtkRMGnw= 1500000 0 531502500 0 ORA: client DHANUSHINVES bank details mandatory fo... ORA 0 0 0 NULL NULL 4 3 1 SBIMutualFund_MF BSE MFSS SBIPSU-GR 192G 192G 10000000 NULL NULL 1000 1 500 0 EQUITY 0 0 0 0 0 NULL 56 0 0 0 NULL NULL 5 QTY P 1
26052890000006 1779961172 559510429 0 1 56 56 DHANUSHINVES DHANUSHINVES MOB SBIPSU-GR BSTAR 914 S LMT C DAY KSPL KARKALA KSPL C _gWJ9NNmIKQ5WDU08d8jFRiOFCqtRtkRMGnw= 1500000 0 531502500 0 ORA: client DHANUSHINVES bank details mandatory fo... ORA 0 0 0 NULL NULL 4 3 1 SBIMutualFund_MF BSE MFSS SBIPSU-GR 192G 192G 10000000 NULL NULL 1000 1 500 0 EQUITY 0 0 0 0 0 NULL 56 0 0 0 NULL NULL 5 QTY P 1
26052890000007 1779961187 910162167 0 1 56 56 DHANUSHINVES DHANUSHINVES MOB UASELSRP-DP BSTAR 51744 S LMT C DAY KSPL KARKALA KSPL C _gWJ9NNmIKQ5WDU08d8jFRiOFCqtRtkRMGnw= 500000 0 50000000 0 ORA: client DHANUSHINVES bank details mandatory fo... ORA 0 0 0 NULL NULL 4 3 0 UNIONMUTUALFUND_MF_SIF BSE MFSS UASELSRP-DP ELSRP UKS 100000000 NULL NULL 1 1 1000 0 EQUITY 0 0 0 0 0 NULL 56 0 0 0 NULL NULL 5 QTY P 1
26052890000008 1779961200 292621525 0 1 56 56 DHANUSHINVES DHANUSHINVES MOB UASELSRP-DP BSTAR 51744 S LMT C DAY KSPL KARKALA KSPL C _gWJ9NNmIKQ5WDU08d8jFRiOFCqtRtkRMGnw= 500000 0 50000000 0 ORA: client DHANUSHINVES bank details mandatory fo... ORA 0 0 0 NULL NULL 4 3 0 UNIONMUTUALFUND_MF_SIF BSE MFSS UASELSRP-DP ELSRP UKS 100000000 NULL NULL 1 1 1000 0 EQUITY 0 0 0 0 0 NULL 56 0 0 0 NULL NULL 5 QTY P 1
26052890000009 1779961881 803928050 0 1 56 56 DHANUSHINVES DHANUSHINVES MOB UASELSRP-DP BSTAR 51744 S LMT C DAY KSPL KARKALA KSPL C _gWJ9NNmIKQ5WDU08d8jFRiOFCqtRtkRMGnw= 560000 0 56000000 0 ORA: client DHANUSHINVES bank details mandatory fo... ORA 0 0 0 NULL NULL 4 3 0 UNIONMUTUALFUND_MF_SIF BSE MFSS UASELSRP-DP ELSRP UKS 100000000 NULL NULL 1 1 1000 0 EQUITY 0 0 0 0 0 NULL 56 0 0 0 NULL NULL 5 QTY P 1
26052890000010 1779962923 64034246 0 1 56 56 DHANUSHINVES DHANUSHINVES MOB SBIPSU-GR BSTAR 914 S LMT C DAY KSPL KARKALA KSPL C _gWJ9NNmIKQ5WDU08d8jFRiOFCqtRtkRMGnw= 1500000 0 531502500 0 ORA: client DHANUSHINVES bank details mandatory fo... ORA 0 0 0 NULL NULL 4 3 1 SBIMutualFund_MF BSE MFSS SBIPSU-GR 192G 192G 10000000 NULL NULL 1000 1 500 0 EQUITY 0 0 0 0 0 NULL 56 0 0 0 NULL NULL 5 QTY P 1
26052990000001 1780030350 98579539 0 1 56 56 DHANUSHINVES DHANUSHINVES MOB UASELSRP-DP BSTAR 51744 S LMT C DAY KSPL KARKALA KSPL C _gWJ9NNmIKQ5WDU08d8jFRiOFCqtRtkRMGnw= 100000 0 10000000 0 ORA: client DHANUSHINVES bank details mandatory fo... ORA 0 0 0 NULL NULL 4 3 1 UNIONMUTUALFUND_MF_SIF BSE MFSS UASELSRP-DP ELSRP UKS 100000000 NULL NULL 1 1 1000 0 EQUITY 0 0 0 0 0 NULL 56 0 0 0 NULL NULL 5 QTY P 1
|
|
|
|
行数：
过滤行:
查询结果操作打印 打印复制到剪贴板 复制到剪贴板导出 导出显示图表 显示图表新建视图 新建视图

将此 SQL 查询加为书签 将此 SQL 查询加为书签