将文件拖动至此

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 
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