Views in SQL

-
What is a View?
A view is nothing more than a saved SQL query. A view can also be considered as a virtual table.

View script 

Create view VIEW_NAME
AS
SELECT T1.CUSTEMOR _NAME, T1.CUST_ID , T1.Address,  T2.Order_units
From CUSTERMORTABLE  AS T1
Inner join  ORDERS AS T2
ON T1.CUST_ID =T2.CUST_ID
Where order_units > = 60  



Comments

Post a Comment

Popular Posts

How to Clean unwanted symbols in a Number column In SQL server ?

-
Image
. How to clean a phone Number In SQL Server ?       I have a table like this. In this table i want to display phone number without (.) symbol. for this we suppose to create a function. Table info: CREATE A USER DEFINED FUNCTION :-  USE BELLOW CODE TO CREATE A FUNCTION IN SQL SERVER(SSMS) create   function  Udf_getNumber   (  @String  Nvarchar ( 200 )) Returns   nvarchar ( 200 ) As Begin Declare  @intalpha  int set  @intalpha  =   PATINDEX ( '%[^0-9]%' , @String ) Begin   while  @intalpha  > 0 Begin set   @String  = STUFF ( @String , @intalpha , 1 , '' ) set  @intalpha  = PATINDEX ( '%[^0-9]%' , @String ) end end Return   isnull ( @String , 0 ) end once create the function use this function to get desired output  note:- use function Fully Qualified name (schema name. function name eg  dbo . Udf_getNumber ...
Read more

class 4 - SQL COMMANDS and sample code to Create tables with constraints

-
- List of SQL commands SQL, 'Structured Query Language', is a programming language designed to manage data stored in relational databases. SQL operates through simple, declarative statements. This keeps data accurate and secure, and helps maintain the integrity of databases, regardless of size. Here's an appendix of commonly used commands. COMMANDS ALTER TABLE ALTER TABLE table_name ADD column datatype;   ALTER TABLE  lets you add columns to a table in a database. AND SELECT column_name(s) FROM table_name WHERE column_1 = value_1 AND column_2 = value_2;   AND  is an operator that combines two conditions. Both conditions must be true for the row to be included in the result set. AS SELECT column_name AS 'Alias' FROM table_name;   AS  is a keyword in SQL that allows you to rename a column or table using an  alias . AVG SELECT AVG(column_name) FROM table_name;   AVG()  is an aggregate function that return...
Read more

Learn useful command prompt commands for Beginners

-
Image
command prompt Beginner Tricks   Every beginner programmer need to learn  command prompt tricks . it will helps you to upgrade and install new packages and access files easily. Open command prompt in your system. as soon as open your prompt  looks like this. once open  your in default directory  C:\Users\CSC>  first learn how to access drive Or Jump to drives for example i am in " C Drive " i want to jump " E Drive " how to do that How to Access Drive?   Jump  " C Drive" to   " E Drive " how to do that   Type E: and hit Enter button  then the prompt looks like this  Now i want to see what are the Folders and files in " E: Drive ". how to do that type Dir   and hit Enter it will list all the Folders and files in E Drive.  in the above list how to find which is folder and which is file     Which one have <DIR> i...
Read more