0
Want this question answered?
Be notified when an answer is posted
Add your answer:
Earn +20 pts
How do you fetch second highest salary from table?
select top 1 * from EMPLOYEE where SALARY < (select MAX SALARY FROM EMPLOYEE) ORDER BY SALARY DESC
What are the goals of employee selection?
To select the best candidate for the task
How do you get the highest pay employee in an oracle database?
Select employee, max(salary) From employee Group by employee Order by one DESC The employee with the max salary will be the first one reported. Another way would be to use a analytical rank function.
How can you get the 3rd highest salary in SQL from employee database?
select * from ( select eno, ename, sal, rank() over(order by sal desc) rnk ) where rnk = 3
What basic clause in an SQL statement is used to retrieve rows and columns from tables?
The SELECT clause is used to retrieve rows and columns from tables. Ex: Select * from employee
Create view in SQL?
create view vw_active_employee as select * from employee where status = 'Active' after creating the view, view can be used as a table to see active employee. e.g. select * from vw_active_employee Basically we save sql as a database object, so that we can use that in future as a virtual table.
How do you fetch the data from already stored database by using php code?
Use the Select statement. As in <?php // If you want all of the data $select = mysql_query("SELECT * FROM table_name"); // where table_name is name of your table // If you want selected data $select = mysql_query("SELECT id, username, password FROM table_name"); // If you want a particular data as in salary of employee named John from table employees $select = mysql_query("SELECT salary FROM employee WHERE Name='john'"); // Remember This only selects the data. Now the fetch part while($fetch = mysql_fetch_array($select)) { // replace the column_name with name of the column fields in database echo $fetch['column_name]; echo $fetch['column_name']; } ?>
Can you use SQL to pull data from Oracle?
yes.... example: select *from employee; dml command in sql language
What employee qualifications are often used to select new supervisors?
The most skilled and experienced employees are often selected as supervisors.
What are the commands of view?
View is a virtual table with no data, but can be operated like any other table. creating a view : create view employee as select * from emp where gross>10000; dropping a view: drop view employee
How do you print your w2 for ulta employee?
If you are an Ulta employee and received an online copy of your W-2, then you can use a computer and a printer to make a physical. Open the file on the computer connected to the printer, then select "Print" from the file menu.
What are the stages of selecting employees?
Advertise the opening. Look over applications. Look over resumes. Choose interviews. Interview. Select employee.
