MS SQL learning record-6
Subquery (Continued)
Comparison operator (Continued) Demonstration: how to use comparison operators in multivalued subqueries
Example A: query all orders with product category No. 1 and return all field data of the order
Subquery
select *
from sales.orders
where orderid in
(
select orderid
from sales.orderdetails
...
Posted by summerpewp on Sun, 30 Jan 2022 00:03:23 +0100
Common methods of sql server right lifting in windows system
1. MSSQL overview
MSSQL(MicroSoft SQL Server database) is a relational database management system DBMS developed by Microsoft. It is a large database and provides a complete solution from server to terminal. The database management system SSMS (SQL Server Management Studio) is an integrated development environment for establishing, using a ...
Posted by jxrd on Fri, 14 Jan 2022 21:42:09 +0100