select top1 :

* FROM SC ORDER BY score DESC

The operation results are as follows :

sc Table data query select top 1
S# C# Score
001 03 120

WITH ties * FROM SC ORDER BY score DESC

The operation results are as follows :

S# C# Score
002 03 120
001 03 120

select top 1 and select top 1 with ties * from SC More articles about the difference between

  1. SELECT TOP 1 No more than TOP 1 Analysis of the reasons for slow and SELECT TOP 1 The principle of statement execution plan prediction

    Source of this article :http://www.cnblogs.com/wy123/p/6082338.html I have met such a situation in reality : In some special situations : When querying , added TOP 1 No more than TOP 1 slower ( and ...

  2. Oracle no TOP, how to get top from order

    On ROWNUM and Limiting Results Our technologist explains how ROWNUM works and how to make it work fo ...

  3. modify select style ,vue select

    <style> .selectbox{ width: 200px; display: inline-block; overflow-x: hidden; height: 28px; lin ...

  4. SQL Server in SELECT It's going to really block SELECT Do you ?

    stay SQL Server in , We know one SELECT During the execution of the statement, only some intentional shared locks will be applied (IS) And shared locks (S), For example I use SQL Profile Tracking session 86 perform SELECT * FROM dbo.T ...

  5. SQLSERVER in SELECT COUNT(1) and SELECT COUNT(*) Which performance is better ?

    SQLSERVER in SELECT COUNT(1) and SELECT COUNT(*) Which performance is better ? Today, I met someone who asked in an article I wrote before If there's no time to update the statistics , Isn't the statistics wrong ...

  6. MySQL select into and SQL select into

    Now there's a table for student, I want to copy the data in this table to a table named dust In the new table , Although you can copy it with the following statement , I always feel uncomfortable , I hope you can help me , thank you .  answer 01: create table d ...

  7. &lt;select&gt; Transform into &lt;s:select&gt; Realize the echo function of the form

    initial : <select name="viewType"> <option value="0"> All topics </option> & ...

  8. Talking about select for update and select lock in share mode The difference between

    In some cases, in order to ensure the consistency of data logic , Need to be right SELECT Lock the operation of .InnoDB Storage engine for SELECT Statement supports two types of consistent lock reads (locking read) operation . . SELECT …… FOR UP ...

  9. mybatis in union It can be used if Judge connection , however &lt;select&gt; First of all select A statement cannot be if Judge , So you can go from dual Query in table null Come and get it together .union If you use order by Sort , Then it can only be placed in the position of the last query statement , And you can't bring a table name .

    <!-- Analysis of taxpayers with one address and multiple certificates --> <select id="yzdznsrlistPage" parameterType="page" r ...

Random recommendation

  1. IE Next Array.prototype.slice.call(params,0)

    i8 I won't support it Array.prototype.slice.call(params,0) params It can be  HTMLCollection. An array of class .string character string

  2. How to integrate maven Import the project MyEclipse

    One . install maven First step : Download an installation free version of apache-maven-3.0.3.zip After decompressing , Configure environment variables newly build M2_HOME:   stay path Add later   %M2_HOME%\bin;   The second step : ...

  3. Linux Next common software

    One , vmtool install , After entering the desktop , If you don't see VMware Tools Compact disc , Please click on VMware Station On the menu bar “ virtual machine ”, And then choose “ install VMware Tools”, You can see it on the desktop ...

  4. PHP And Mysql Add, delete, change and check operation cases

    1:user surface : CREATE TABLE `user` ( `id` ) NOT NULL AUTO_INCREMENT, `name` ) NOT NULL, PRIMARY KEY (`id`) ...

  5. solve Geoserver Several ideas of cross domain request

    The copyright of the article is jointly owned by Li Xiaohui and blog park , If reprint, please indicate the source clearly :http://www.cnblogs.com/naaoveGIS/ 1. Background description Cross domain problem is a very common problem caused by browser's homologous security system . Different frontiers ...

  6. ftp Timing task - Log backup

    1. install #yum -y install vsftpd 2. Modify the configuration file #vi /etc/vsftpd/vsftpd.conf FTP The default directory for the server is /var/ftp, And when the user logs in anonymously ...

  7. Go-day07

    Summary of today's content : 1.json analysis 2. File operations 3. Command line arguments 4. Error handling One .Golang Type assertion in 1 em It has to be for initerface Type can be used for type assertion For example, the following code will report an error s := &q ...

  8. JSON WEB TOKEN, Simple talk TOKEN The use of and in C# In the implementation of

    Ten years of Hedong , Ten years in Hexi , Don't deceive young people into being poor . knowledge has no limit , Keep improving . I suddenly found that I haven't written a blog in October ...... Ah , It's all tears , There have been too many overtime recently , I really don't have time to blog . see , Working overtime today, too ...

  9. TCP/IP Four layer model explains notes

    Reprinted from :http://www.vuln.cn/2041 OSI Seven layer model   The presentation layer : Used to decode different formats into machine language , And other functions . The session layer : Determine whether network transmission is needed . Transport layer : Identify the port to specify the server , E.g ...

  10. linux Of swap relevant

    linux In general, the memory scheme adopted by the system is Physical memory +swap. Physical memory for everyday use ,swap It's for emergencies . But in the process of actual use , It is found that sometimes the physical memory is not fully occupied , Already in use swap 了 . And then , from ...