Today, We want to share with you sql examples.In this post we will show you sql interview questions, hear for sql commands with syntax and examples we will give you demo and example for implement.In this post, we will learn about sql online tutorial with an example.
sql queries examples with answers
In this tutorial we learn to all about sql examples Examples like as a SQL SELECT, WHERE, AND, OR and NOT Operators, MIN() and MAX(), COUNT, AVG() and SUM() or many more.
Also Read: sql subquery examples
SELECT MemberName, Location FROM Members;
SELECT * Example
SELECT * FROM Members;
SQL SELECT DISTINCT
SELECT DISTINCT Districts FROM Members; //or SELECT Count(*) AS DistinctCountries FROM (SELECT DISTINCT Districts FROM Members);
SELECT * FROM Members WHERE Districts='Surat';
SQL AND, OR and NOT Operators
SELECT * FROM Members WHERE Districts='Jammnagar' AND Location='Bhavanagar'; SELECT * FROM Members WHERE Location='Bhavanagar' OR Location='Paladi char rasta'; SELECT * FROM Members WHERE NOT Districts='Jammnagar';
SELECT * FROM Members WHERE Districts='Jammnagar' AND (Location='Bhavanagar' OR Location='Paladi char rasta');
SQL ORDER BY
SELECT * FROM Members ORDER BY Districts DESC;
SQL INSERT INTO
INSERT INTO Members (MemberName, ProfileNm, Address, Location, PostalCode, Districts) VALUES ('Bhakti', 'Soratiya B. Jala', 'Dhara 21', 'Om Nagar', '360002', 'Rajkot');
SQL NULL Values
SELECT MemberName, ProfileNm, Address FROM Members WHERE Address IS NULL;
UPDATE Members SET ProfileNm = 'Ajmera Hitesh', Location= 'Gondal Chokadi' WHERE MemberID = 1;
UPDATE Multiple Records
UPDATE Members SET ProfileNm='Munoj' WHERE Districts='Surat';
DELETE FROM Members WHERE MemberName='Chanagani Yagnika'; // Delete All Records DELETE FROM tamilrokers_tbl;
SQL SELECT TOP
SELECT TOP 3 * FROM Members; //or SELECT * FROM Members LIMIT 3;
SQL MIN() and MAX()
SELECT MIN(Amount) AS SmallestAmount FROM Mobiles;
SELECT MAX(Amount) AS LargestAmount FROM Mobiles;
SQL COUNT, AVG() and SUM()
SELECT COUNT(MobileID) FROM Mobiles;
SELECT AVG(Amount) FROM Mobiles;
SELECT SUM(Quantity) FROM OrderDetails;
SELECT * FROM Members WHERE Location LIKE '%mn%'; //or SELECT * FROM Members WHERE Location LIKE '_try'; //or SELECT * FROM Members WHERE Location LIKE 'M_k_pi'; //or SELECT * FROM Members WHERE Location LIKE '[jdk]%';
SELECT * FROM Members WHERE Districts IN ('Jammnagar', 'Surat', 'Ahemdabad');
SELECT * FROM Mobiles WHERE Amount BETWEEN 10 AND 20;
SELECT MemberID AS ID, MemberName AS Member FROM Members;
I hope you get an idea about sql examples.
I would like to have feedback on my infinityknow.com blog.
Your valuable feedback, question, or comments about this article are always welcome.
If you enjoyed and liked this post, don’t forget to share.