{"id":3079,"date":"2017-08-21T14:54:44","date_gmt":"2017-08-21T14:54:44","guid":{"rendered":"https:\/\/answers.gurussolutions.com\/answers\/recuperation-du-premier-enregistrement-dans-mysql-simulation-de-la-fonctionnalite-first\/"},"modified":"2026-07-28T18:25:28","modified_gmt":"2026-07-28T18:25:28","slug":"recuperation-du-premier-enregistrement-dans-mysql-simulation-de-la-fonctionnalite-first","status":"publish","type":"qa_entry","link":"https:\/\/answers.gurussolutions.com\/fr\/answers\/recuperation-du-premier-enregistrement-dans-mysql-simulation-de-la-fonctionnalite-first\/","title":{"rendered":"R\u00e9cup\u00e9ration du premier enregistrement dans MySQL : simulation de la fonctionnalit\u00e9 FIRST()"},"content":{"rendered":"","protected":false},"template":"","meta":{"_kad_blocks_custom_css":"","_kad_blocks_head_custom_js":"","_kad_blocks_body_custom_js":"","_kad_blocks_footer_custom_js":"","_kadence_starter_templates_imported_post":false,"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"_kad_post_classname":"","ga_subtitle":"D\u00e9couvrez comment extraire efficacement la premi\u00e8re ligne d'un r\u00e9sultat de requ\u00eate MySQL, notamment les m\u00e9thodes applicables aux anciennes versions et l'utilisation de la fonction FIRST_VALUE() dans MySQL 8.0 et versions ult\u00e9rieures.","ga_short_answer":"Pour les anciennes versions de MySQL, r\u00e9cup\u00e9rez le premier enregistrement en triant vos r\u00e9sultats et en appliquant une clause LIMIT 1. Cette m\u00e9thode simule efficacement une fonction FIRST(). Pour MySQL 8.0 et les versions ult\u00e9rieures, la fonction de fen\u00eatre FIRST_VALUE() permet de s\u00e9lectionner directement la premi\u00e8re valeur au sein d\u2019une partition.","ga_scenario":"Les utilisateurs ont souvent besoin de r\u00e9cup\u00e9rer uniquement le tout premier enregistrement d\u2019un ensemble de donn\u00e9es dans MySQL, \u00e0 l\u2019instar du fonctionnement de la fonction d\u2019agr\u00e9gation FIRST() dans d\u2019autres dialectes SQL. La difficult\u00e9 r\u00e9side dans le fait que MySQL ne dispose traditionnellement pas d\u2019une fonction d\u2019agr\u00e9gation FIRST() directe et d\u00e9di\u00e9e \u00e0 cette fin.","ga_solution":"Bien que MySQL n\u2019ait traditionnellement pas inclus de fonction d\u2019agr\u00e9gation FIRST() directe, il existe des m\u00e9thodes efficaces pour r\u00e9cup\u00e9rer le premier enregistrement d\u2019un jeu de r\u00e9sultats. Pour MySQL 8.0 et les versions ult\u00e9rieures, la fonction de fen\u00eatre FIRST_VALUE() offre une solution directe.Pour r\u00e9cup\u00e9rer le premier enregistrement d\u2019un jeu de r\u00e9sultats, notamment dans les anciennes versions de MySQL ou lorsqu\u2019un agr\u00e9gat simple est n\u00e9cessaire :\n1.  Triez les r\u00e9sultats selon l\u2019ordre souhait\u00e9.\n2.  Limitez le r\u00e9sultat \u00e0 une seule occurrence. Cela permettra de s\u00e9lectionner efficacement le premier enregistrement en fonction de l\u2019ordre de tri d\u00e9fini.Exemple utilisant ORDER BY et LIMIT :\n\n```\nsqlSELECT column_nameFROM your_tableORDER BY sort_column ASC LIMIT 1;\n```\n\nPour MySQL 8.0 et les versions plus r\u00e9centes, la fonction de fen\u00eatre FIRST_VALUE() peut \u00eatre utilis\u00e9e pour obtenir la premi\u00e8re valeur au sein d\u2019une fen\u00eatre ou d\u2019une partition sp\u00e9cifi\u00e9e :\n\n```\nsqlSELECT    column_name,    FIRST_VALUE(column_name) OVER (ORDER BY sort_column ASC) AS first_value_in_partitionFROM    your_table;\n```","ga_source_author":"","ga_source_author_email":"","ga_date_original":"2017-08-21T16:54:44+02:00","ga_date_verified":"2026-07-05","ga_source_subject":"SOL0225 MySQL tips","ga_ans_id":"ANS-1340","ga_publish_decision":"publish_with_edits","ga_staleness_risk":"high","ga_review_priority":"verify_soon","ga_tier2_verdict":"partially_outdated","ga_tier2_concerns":"The claim 'No such thing as the method first on MySQL' is partially outdated due to the introduction of the FIRST_VALUE() window function in MySQL 8.0 and later versions.","ga_final_category":"Other \/ Uncategorized","footnotes":""},"ga_category":[109,31,109],"ga_audience":[10],"ga_difficulty":[93],"class_list":["post-3079","qa_entry","type-qa_entry","status-publish","hentry","ga_category-autres","ga_category-other","ga_audience-developer-suitescript","ga_difficulty-debutant"],"taxonomy_info":{"ga_category":[{"value":109,"label":"Autres"},{"value":31,"label":"Other"},{"value":109,"label":"Autres"}],"ga_audience":[{"value":10,"label":"Developer\/SuiteScript"}],"ga_difficulty":[{"value":93,"label":"D\u00e9butant"}]},"featured_image_src_large":[],"author_info":[],"comment_info":"","_links":{"self":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry\/3079","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry"}],"about":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/types\/qa_entry"}],"version-history":[{"count":1,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry\/3079\/revisions"}],"predecessor-version":[{"id":4999,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry\/3079\/revisions\/4999"}],"wp:attachment":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/media?parent=3079"}],"wp:term":[{"taxonomy":"ga_category","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_category?post=3079"},{"taxonomy":"ga_audience","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_audience?post=3079"},{"taxonomy":"ga_difficulty","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_difficulty?post=3079"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}