BASIC SELECT Statement:
Syntax:
SELECT *|{[DISTINCT] column|expression [alias],...}
FROM table;
1. Display all rows and all columns of emp table
2. Display any 2 columns of emp table
3. Calculate annual salary with Quarterly commission of 500
4. Display distinct salaries of all the employees
5. Display output as following,
"Hello SMITH your salary is 5000"
6. Is the following statement correct,
SeleCT ENAME,deptno FROM emp;
select *,ename from emp;
select ename deptno from emp;
2. Display any 2 columns of emp table
3. Calculate annual salary with Quarterly commission of 500
4. Display distinct salaries of all the employees
5. Display output as following,
"Hello SMITH your salary is 5000"
6. Is the following statement correct,
SeleCT ENAME,deptno FROM emp;
select *,ename from emp;
select ename deptno from emp;
Comments
Answers for the Basic SQL stmt are not available. Please recheck and post the same.
Thnaking you
Namrata
Select Min(salary) as 5thsalary From (Select Top 5 salary From Employee Order by salary Desc);
Thanking You,
MohanRaj.K.E
ppl teach only basic sql n tey dont evene try to concentrate on different types of questions being asked ur tutorial has really improvised my sql skill a lot
THANKING YOU
AFIFA KAUSER.Z