sql query to compare two columns in same table

Label:There is a business scenario where a single piece of data in the main table has multiple detail data in the child table. When the data is displayed, the product wants to be free to take a sub-table of data associated with the display, with a lot of solutions, but not good enough. SQL

Label:SELECT * FROM (SELECT Tt.*,rownum RN from(SELECTa.case_id as Treatid,A.type as TYPE,B.content as CONTENT,b.add_user_id as Adduserid,B.add_user_type as Addusertrpe,A.create_time as Createtime,B.check_time as Checktime,E.addusertypeFrom T_medical_case ALeft JOIN t_treatment B on a.case_id = b.treat_idLeft JOIN (select c.patient_id as ID, C.user_name, ' 2 ' as AddusertypeFrom T_patient_info CUNIONSelect d.doctor_id as ID, D.user_name, ' 1 ' as AddusertypeFrom T_doctor_info D) E on b.add_user_

The following is an example:Two tables, SourceTable and TargetTable, are logon tables. If the user accesses the login table, update the authorization level of the authorization table. Otherwise, authorization 0 indicates the visitor. The SQL statement is as follows:-- SourceTable: logon table, TargetTable: Authorizatio

the first table with all records of the second table once and back, is useful when generating a test database, for example, you define 7 last names, 7 names, and then cross-connect to generate 49 records. If you have the following table: Last Name table 　　　　 Name table: 　　　

Tags: int www eric ble base pen query using varcharSQL uses parameters in OpenQueryDECLARE @tmptable as TABLE (ccode nvarchar, str1 nvarchar, str15 nvarchar (255), Fhglid NUMERIC)DECLARE @sql VARCHAR (+) = ' CC003 'SET @sql = ' SELECT ' from DATABASE.dbo.getBTXX (' [email protected]+ ') 'SET @

In the case of a large record, the not in query will certainly be slow and unacceptable. Like what:SELECT A.* fromWHERE A.user_id not in (SELECT B.user_id from Table_b)the best way to find it now is to check it in seconds. For example, query the DEPT_ID data with table A and b not available:SELECT A.*from tb_dept A, Tb_dept_lev BWHERE= b.dept_id (+) and is NU

Tags: lock table Database unlockBefore the operation of the program, the sudden occurrence of the page card dead, the background does not error, after troubleshooting is the database table is locked dead, the following SQL is the query is locked table, as well as the corresp

same as the result shown in the inner join. Four, two-table relationship is One-to-many, one-to-many or Many-to-many connection statement Of course the above two tables are one-to-one, so if Table A and table B are one-to-many, One-to-many, or many-to-many, how do we write connected SQL statements? In fact, two mor

number =A. Employee number)Note: this should be done to find out the maximum value of each employee's order amount, along with the information of the employee's corresponding order.Many people do this:SELECT * from order form where amount in (select Max (amount) from order Form group by employee number)This practice is wrong.3.6 quantifier QueryCommonly used quantifiers any, all, and some, where any and some are synonyms, as long as the subquery has a true, true, and all of the behavior in the

Tags: tar create done Project class User A mat statusReference: https://bbs.csdn.net/topics/330032307There is a dictionary table in the database, which contains the ID field and the corresponding name fields.In another record table, there is a corresponding ID for the dictionary table above, and there are multiple fields that contain the ID field. It needs to be

Tags: style time span stat name not sel tab DUPI'm using a statement to save the queried data to a new table 1) using the into table statement, the new table that needs to be saved does not need to be created in advance Select * to from table-Insert new Table statement in

In SQL ServerEach database has a table generated by the system.The table sysobjects records all the table names in the database.We can use the following SQL syntax for query operations. Copy codeThe Code is as follows:Select Name