free download sql server commands...

by barkkathulla 2012-09-22 12:04:56

5. SELECT * FROM SCM WHERE SALARY<5000

6. SELECT * FROM SCM WHERE SALARY<>3500

7. SELECT * FROM SCM WHERE SALARY BETWEEN
5000 AND 7000

8. SELECT * FROM SCM WHERE SALARY NOT
BETWEEN 5000 AND 7000

9. SELECT NAME FROM SCM

10. SELECT NAME FROM SCM WHERE SALARY>5000

11. SELECT NAME,DEPARTMENT FROM SCM

12. SELECT * FROM SCM WHERE SALARY>5000 AND DEPARTMENT=”COMPUTER”

13. SELECT DISTINCT(DEPARTMENT) FROM SCM

14. SELECT * FROM SCM ORDER BY NAME

15. SELECT * FROM SCM ORDER BY NAME DESC

16. SELECT * FROM SCM WHERE NAME LIKE “R%”

17. SELECT * FROM SCM WHERE NAME LIKE “_N%”

18. SELECT * FROM SCM WHERE NAME LIKE “%N%”

19. SELECT * FROM SCM WHERE NAME LIKE”%N”

20. SELECT * FROM SCM WHERE NAME NOT LIKE “R%”

21. SELECT SUM(SALARY) FROM SCM

22. SELECT AVG(SALARY) FROM SCM

23. SELECT MAX(SALARY) FROM SCM

24. SELECT MIN(SALARY) FROM SCM

25. SELECT COUNT(NAME) FROM SCM

26. SELECT MAX(SALARY),MIN(SALARY) FROM SCM

27. SELECT LOWER(NAME) FROM SCM

28. SELECT UPPER(NAME) FROM SCM

28.SELECT DEPARTMENT,SUM(SAL) FROM SCM GROUP
BY DEPARTMENT.
29.SELECT NAME,DEPARTMENT,SALARY FROM SCM COMPUTE AVG(SALARY).

30.SELECT NAME,DEPARTMENT,SALARY FROM SCM ORDER BY DEPARTMENT COMPUTE SUM(SAL) BY DEPARTMENT.

31.SELECT SUM(SAL) "SUM OF SALARY" FROM SCM

32.SELECT UPPER(NAME) "UPPER" FROM SCM

33.SELECT LOWER(NAME) "LOWER" FROM SCM
702
like
0
dislike
0
mail
flag

You must LOGIN to add comments