How to formate in sql
select ProductName, Price, FORMAT(Now(),'YYYY-MM-DD')......
Saturday, 14 May 2016
How to use now function in sql
select ProductName, Price, Now() AS PerDatefrom......
How to get round price in sql
select ProductName, ROUND(Price,0) AS RoundedPricefrom......
How to get sum value in sql
select SUM(Quantity) AS TotalOrdered from OrderD......
How to get min value in sql
select MIN(Price) AS smallOrderPrice from Produ......
Penulis
How to get maximum value in sql
select MAX(Price) AS HighestPrice form Produ......
How to count() function in sql
select COUNT(ClientID)AS OrderFormClientID1......
How to average price value in sql
select ProName, Price From Product where......
How to database & table drop in sql
Table:
DROP TABLE Client(table name).
Database:
DROP......
How to create foreign key in sql
Order table(ord_Id int NOT NULL,OrderNo int......
How to create primary key in sql
Client Table(Client _Id int NOT NULL PRIMARY......
How to union operator in sql database
SELECT City FROM ClientUNIONSELECT City......
How to full join in sql
SELECT Client.ClientName, Product.ProductID
FROM Client
FULL......
How to right join in sql
SELECT Product.ProductID, Client.Name
FROM Product
RIGHT......
How to left join in sql
SELECT Client.ClientName, Product.ProductID
FROM Client
LEFT......
How to INNER Join in sql database
SELECT Client.ClientName, Orders.OrderIDFROM......
How to table join in sql
SELECT Product.ProductID, Client.ClientName, Product.ProductDate
FROM......
How to delete data in database sql server
DELETE FROM Client
WHERE Name='Dovi'......
How to update data in sql server database
UPDATE Client
SET Name='Dovi', City='London'
WHERE......
How to insert data in sql database
INSERT INTO ClientVALUES (name,address,City,...);
Column......
How to create table in sql server
Client Table :
Product Table:
......
Subscribe to:
Posts (Atom)