some common used Query :-
use adventureworks
select * from person.address
select addressid, addressline1, city, postalcode from person.address
----------------- conditions-----------------------
select * from person.contact
select contactid, firstname, lastname, emailaddress from person.contact
select contactid, firstname, lastname, emailaddress from person.contact
where contactid = 10
select contactid, firstname, lastname, emailaddress from person.contact
where contactid < 10
select contactid, firstname, lastname, emailaddress from person.contact
where contactid > 10
-----------------------adition of atributes------------------
select * from sales.creditcard
select cardtype +'=========='+ cardnumber as 'result' from sales.creditcard
select creditcardid, cardtype, expyear from sales.creditcard where expyear > 2002
--------------------for changing name of the colum------------
select * from Sales.SalesTaxRate
select 'id'= salestaxrateid from Sales.SalesTaxRate
------------------------------------------------------------------------------------------------------------
use adventureworks
select * from sales.creditcard
select * from sales.creditcard where creditcardid = 3 and expmonth = 7
select * from sales.creditcard where creditcardid = 77770000 or expmonth = 10
select * from sales.creditcard where not cardtype = 'vista'
--------------------------range operator-------------------------------------------------------------------
select * from sales.creditcard where creditcardid between 10 and 20
select * from sales.creditcard where creditcardid not between 15 and 50
---------------------------- experssion operator-----------------------------------------------------------
select * from sales.creditcard where creditcardid in (1,2,3,4,5)
select * from sales.creditcard where cardtype not in('vista')
----------------------------------wild card-----------------------------------------------------------------
---'%'
---'_'
--'[]'
----'[^]'
select * from person.contact
select * from person.contact where firstname like 'ron%'
select * from person.contact where firstname like '%ald'
select * from person.contact where firstname like 'k__'
select * from person.contact where firstname like '[kr]%'
----------------------------------null------not null----------------------------------------------------------
select * from person.contact where middlename is null
select * from person.contact where middlename is not null
-----------------------------------------top----------------------------------------------------------------
select top 5 * from person.contact order by contactid desc
------------------------------------------ distinct----------------------------------------------------------
select distinct * from person.contact
-----------------------------------string function -----------------------------------------------------------
select ascii(firstname) from person.contact
select char('98')
select * from person.contact
------------------------------------------------------------------------------------------------------------
