CODEWITHSUNDEEP
sql-serveradventureworks
Captain Smith
Captain Smith

Reputation: 1

Please generate dataset that will display the PreAssemblyQty and BomLevel that have PreAssemblyQty less than or equal to 8.00 (adventureworks 2016)

Please generate dataset that will display the PreAssemblyQty and BomLevel that have PreAssemblyQty less than or equal to 8.00

SELECT PreAssemblyQty, BomLevel
FROM YourTableName -- Replace YourTableName with the actual name of your table
WHERE PreAssemblyQty <= 8.00;

help me find the table name

Upvotes: -1

Views: 25

Answers (1)

nbk
nbk

Reputation: 49375

With

USE AdventureWorks2016;  
GO  
SELECT
    TABLE_NAME,
COLUMN_NAME
FROM
    INFORMATION_SCHEMA.COLUMNS

WHERE COLUMN_NAME = 'BomLevel';  
GO

You find your table

enter image description here

Upvotes: 0

Related Questions