Syntax for getting the table witout any contents
create table emp as select * from student where 1=2;
select * from faculty where rownum=0;
How to get fifth maximum salary from the table with out using top keywork(without any keywords) in SQL server 2000can you please guide me about this?
select sal from emp ewhere 4=(select count(distinct(sal) from emp where sal>e.sal)
SELECT * FROM (SELECT ename ,sal, dense_rank() over (ORDER BY sal DESC) max_sal FROM emp)WHERE max_sal= 5;
What do you think about our company?
How do you approach a problem?
Do you like working in a team or alone? Explain.
How do you handle pressure and stress?
How do you handle conflict?
Tell me three things about you, which are not found in your resume
Have you gone above and beyond your job description?
What are the career options available in Software Testing Industry?
How to Overcome Employment Gap during interview.
How to handle academic gap while applying for a job?
Ask Interview Question?
Have Career Question?
Ask Only Career questions.