Into га доир
Download 184.77 Kb. Pdf ko'rish
|
Шпаргалка
|
INSERT
INTO ГА ДОИР
1. INSERT
INTO
`` ( `` , ``
) VALUES
( '' , '' )
+ 2.
INSERT
INTO
`` ( `` , ``
) VALUES
( '' , '' ), (
'' , '' ) +
3.
INSERT INTO
`` ( `` , `` , `` , `` , `` , `` , `` , `` ) VALUES ( '' ,
'', '' , '' , '' , '' ,
'' ,
'' )
+ SELECT ГА ДОИР
SELECT
``, ``, `` FROM
`` + 5. SELECT
TOP N ``, ``, `` FROM
`` + 6. SELECT
`` , `` , ``
FROM ``
+ DELETE ГА ДОИР
DELETE
FROM
``
- 8.
DELETE FROM
`` WHERE
`` =
''
+ 9.
INSERT INTO
`` ( `` , `` ) VALUES
( '' , '' )
+
UPDATE га диор 10.
UPDATE ``
SET ``
=
''
- 11. UPDATE
`` SET
`` =
''
WHERE `` =
''
+ 12. UPDATE
`` SET
`` =
' ' , `` =
'' WHERE ``
=
'' + Амаллар 13.
SELECT ``
, `` * 12 FROM
``
+ 14. SELECT
`` , `` FROM ``
where ``
. `` > a * 4 + 15. SELECT `` ``
. `` * .0065 FROM
``
+ 16. UPDATE
`` SET
`` = `` * 1.1
+ 17. SELECT ``
, `` , `` FROM
``
where ( `` > a * 5 and
`` >= 7 )
+ 18. SELECT
`` , `` FROM ``
where
not( `` < a * 5 )
+ DISTINCT
19.
SELECT
DISTINCT `` FROM
``
+ BETWEEN
20. SELECT
`` , `` , ``
FROM ``
WHERE
`` between
5 and
12 ;
+ IN
21.
SELECT ``
, ``
, ``
FROM ``
WHERE
`` not
in(
5 , 10 )
+ LIKE
22. SELECT ``
, ``
, ``
FROM ``
WHERE
`` like
''
+ isNUll
23.
SELECT ``
, ``
, ``
FROM ``
+ WHERE
`` is
not
null 24.
SELECT ``
, ``
, ‘ FROM ``
WHERE `` is
null
+ NOT
25. SELECT ``
, `` , `` FROM
``
where not
`` > a * 5 and `` >= 7 + ORDER BY
26.
SELECT
`` FROM
`` order
by `` desc
+ 27.
SELECT `` FROM
`` order
by `` + group by 28.
SELECT ``i FROM `` group by ``i + HAVING 29.
SELECT
``i FROM
`` group
by ``i having ``i
> 1
+ Статик функциялар
30.
SELECT
'MAX'
= MAX
( `` ), 'MIN' = MIN ( `` ) FROM
``
+ 31.
SELECT COUNT
( `` ) FROM ``
where ``
>= 5
+ 32.
SELECT
SUM
( `` ) FROM
``
+ 33.
SELECT COUNT
( distinCT
``i )
FROM ``
+ 34. SELECT
COUNT
(*) FROM
``
+ 35.
SELECT AVG
( `` ) FROM ``
+
IN
36. SELECT
`` from
`` WHERE
``i in
( select
`` from
`` where
`` =
'' )
+
EXISTS
37. SELECT
`` . `` from ``
WHERE
EXISTS ( select `` from
`` where
`` =
'' )
+
ANY and ALL 38.
SELECT
``i from
`` group
by ``i having ``i
=
ANY( SELECT ``
FROM ``
)
+ 39.
SELECT ``i from
`` group
by ``i having ``i
=
ALL( SELECT ``
FROM ``
)
+ CONVERT and CAST
SELECT
`` FROM
`` where
CONVERT
( int
, telefonHome )
0
+ 41.
SELECT CAST
( `` as
char ) FROM
``
+ CASE
42.
select
`` ,
case
when `` <= 500000
then
'' when
( `` > 500000 and
`` < 1000000
)
then ''
else
''
end
FROM `` ;
+
COALESCE
43. SELECT
`` , coalesce ( `` ,- 1 ) + FROM
``
NULLIF
44.
SELECT `` , NULLIF ( `` , '' )
AS NNN
FROM
``
+ Боғланишлар
45.
SELECT
`` , `` from ``
, ``
where ``
. ``i
= ``
. ``
+ 46.
SELECT
`` , `` from ``
inner
join `` ON `` . ``i
= ``
. ``
+ 47.
SELECT
`` , `` from ``
Full
outer join
`` ON `` . ``i
= ``
. ``
+ 48.
SELECT
`` , `` from ``
Left
outer join
`` ON `` . ``i
= ``
. ``
+ 49.
SELECT
`` , `` from ``
RIGHT
outer join
`` ON `` . ``i
= ``
. ``
+ 50.
SELECT
`` , `` from ``
, ``
+ 51.
SELECT
`` , `` from ``
cross
join ``
+ 52.
SELECT `` , `` from ``
cross
Join `` where
`` . ``i = ``
. ``
+
UNION 53.
(SELECT
`` from
`` where
`` < 6 * a ) UNION ( SELECT `` from
`` inner
join
`` ON `` . ``i
= ``
. ``
where ``
. ``
= '' ) +
Ёзув функциялари
54. SELECT First(``)FROM `` a+ 55.
select
Ucase ( `` )
from ``
a+ 56.
select LCASE ( `` )
from ``
a+ 57.
select UPPER
( `` ) from
``
s+ 58.
select LOWER
( `` ) from
``
s+ 59.
select LAST
( `` ) from
``
a+ 60.
select M``(``,1,1) from `` a+ 61.
select
`` from
`` where
SUBSTRING ( ``
1 , 1 )=
'A' s+
62.
select len
( `` ) from
``
+ 63.
select `` ,
Now ()
as ``
from ``
a+
64.
select Round
( `` ) from
``
a+,+ 65.
select `` , FORMAT ( Now
(), 'YYYY-MM-DD' )
PerDate from
``
Download 184.77 Kb. Do'stlaringiz bilan baham: 
|