Feb 25 2008 10:49 AM 2841 3 Types of Databases pavuluri How many types of databases are there? What are they? akavitha Profile Answers by akavitha Questions by akavitha Feb 28th, 2008 These days when we talk abt database we are mainly talking about 2 databases namely : Analytical DatabaseOperational DatabaseAnalytical Database : Like OLTP( On Line Analytical Processing) are p... Answer Question Select Best Answer May 29 2006 04:24 AM 24860 64 Now suppose i have 50 records of employee table.1) I want to find the person who is having 22nd highest salary.2)i want to delete a person with postion number 39 with comminsion < 1003) Update rec no 45records are not shown.how do i do it. Sriharsha ashish ubale Mar 10th, 2016 Parvathi, last query(update) will set all recno to 45. Because it does not have where condition. neha lakhani Jul 20th, 2014 Employe2 mains emp2 salary < compar to emp1 salary Answer Question Select Best Answer Feb 21 2006 07:21 PM 32446 58 Write a query to find the second largest value in a given column of a table Thiagu1978 PUJA Oct 21st, 2017 SELECT * FROM(SELECT DENSE_RANK() OVER (ORDER BY SAL DESC) AS RNK FROM EMPLOYEE) WHERE RNK=2; dedeepya May 31st, 2017 "sas Data ds; Infile datalines; ... Answer Question Select Best Answer
Feb 25 2008 10:49 AM 2841 3 Types of Databases pavuluri How many types of databases are there? What are they? akavitha Profile Answers by akavitha Questions by akavitha Feb 28th, 2008 These days when we talk abt database we are mainly talking about 2 databases namely : Analytical DatabaseOperational DatabaseAnalytical Database : Like OLTP( On Line Analytical Processing) are p... Answer Question Select Best Answer
akavitha Profile Answers by akavitha Questions by akavitha Feb 28th, 2008 These days when we talk abt database we are mainly talking about 2 databases namely : Analytical DatabaseOperational DatabaseAnalytical Database : Like OLTP( On Line Analytical Processing) are p...
May 29 2006 04:24 AM 24860 64 Now suppose i have 50 records of employee table.1) I want to find the person who is having 22nd highest salary.2)i want to delete a person with postion number 39 with comminsion < 1003) Update rec no 45records are not shown.how do i do it. Sriharsha ashish ubale Mar 10th, 2016 Parvathi, last query(update) will set all recno to 45. Because it does not have where condition. neha lakhani Jul 20th, 2014 Employe2 mains emp2 salary < compar to emp1 salary Answer Question Select Best Answer
ashish ubale Mar 10th, 2016 Parvathi, last query(update) will set all recno to 45. Because it does not have where condition.
Feb 21 2006 07:21 PM 32446 58 Write a query to find the second largest value in a given column of a table Thiagu1978 PUJA Oct 21st, 2017 SELECT * FROM(SELECT DENSE_RANK() OVER (ORDER BY SAL DESC) AS RNK FROM EMPLOYEE) WHERE RNK=2; dedeepya May 31st, 2017 "sas Data ds; Infile datalines; ... Answer Question Select Best Answer
PUJA Oct 21st, 2017 SELECT * FROM(SELECT DENSE_RANK() OVER (ORDER BY SAL DESC) AS RNK FROM EMPLOYEE) WHERE RNK=2;