BuboFlash - helps with learning

Do you want BuboFlash to help you learning these things? Or do you want to add or correct something? Click here to log in or create user.

Presentation
Question

Answer

Tags

#SQL #Server #Technet #Transact

Question

Example - Select all fields from one table

Answer

Example - Select all fields from one table

Let's look at how to use a SQL Server SELECT query to select all fields from a table.

 SELECT *
FROM inventory
WHERE quantity > 5 ORDER BY inventory_id ASC;

If you want to change selection, open document below and click on "Move attachment"

SQL Server: SELECT Statement
rows to only those whose the condition is TRUE. ORDER BY expression Optional. It is used to sort the records in your result set. ASC sorts in ascending order and DESC sorts in descending order. <span>Example - Select all fields from one table Let's look at how to use a SQL Server SELECT query to select all fields from a table. SELECT * FROM inventory WHERE quantity > 5 ORDER BY inventory_id ASC; In this SQL Server SELECT statement example, we've used * to signify that we wish to select all fields from the inventory table where the quantity is greater than 5. The result set is s

Summary

status	not learned	measured difficulty	37% [default]	last interval [days]
repetition number in this series	0	memorised on		scheduled repetition
scheduled repetition interval		last repetition or drill

Details

No repetitions

Discussion

Do you want to join discussion? Click here to log in or create user.