Catégorie : sql

SQL à Linq Converter select top 10 p.Nombre, p.Apellidos, (SELECT COUNT(*) FROM Personas ps WHERE PS.ParentCode LIKE ‘%’ + CONVERT(VARCHAR, p.id) + ‘-%’ ) Total […]

SQL ayant une clause SELECT COUNT(customer_id), country FROM Customers GROUP BY country HAVING COUNT(customer_id) > 1;

Syntaxe Union dans Oracle SELECT column_list_1 FROM T1 UNION SELECT column_list_1 FROM T2;

BigQuery Obtenez la date actuelle SELECT CURRENT_DATE() AS the_date;

Postgres Alter Table Ajouter une clé primaire — To set a column as primary key: ALTER TABLE distributors ADD PRIMARY KEY (tablename); La Source

Obtenez toutes les bases de données et leurs tables sans clé principale MySQL select tab.table_schema as database_name, tab.table_name from information_schema.tables tab left join information_schema.table_constraints tco […]

SQL Update From Select UPDATE YourTable SET Col1 = OtherTable.Col1, Col2 = OtherTable.Col2 FROM ( SELECT ID, Col1, Col2 FROM other_table) AS OtherTable WHERE OtherTable.ID […]

MySQL Find_in_Set Rejoignez SELECT table_categories.name, count(table_products.id) FROM table_categories LEFT JOIN products ON FIND_IN_SET(table_categories.id, products.cid) GROUP BY table_categories.name La Source

Comment configurer le courtier de service dans SQL Server –How to configure service broker 1. Enable the Service Broker on the database 2. Create valid […]

Obtenez les 3 premières lettres dans SQL SELECT FIRST_NAME , SUBSTR(FIRST_NAME, 1 , 3 ) , LENGTH(FIRST_NAME) FROM EMPLOYEES ; SQL Server Sousstring SELECT SUBSTRING(‘SQL […]