-
How to select the recently UPDATED records from the table?
Ayyappa
- Aug 24th, 2012
Hello leelakrishna302 ... Your query ...
gives only latest inserted records not the latest updated records..Code -
-
Suppose there are two fields in table(Employee) say Name and Salary and there are in total 100 records in table. Now my query gives the name of an employee whose salary is 10th among 100 salaries. this query should be solve in SQL not in PL/SQL
abhikum.402
- Aug 13th, 2012
Select emp_name from (select *,Dense_RANK()over (order by Emp_sal) SalayRank from Emp_a)A
where SalayRank=10 -
-
Records Count
How to count number of records in a table without using COUNT function?
Sandipan
- Sep 6th, 2012
Select sum(1) from emp;
Codesmily08
- Aug 30th, 2012
Select max(rownum) from
(select ROW_NUMBER() over (order by col_name) as rowNum from table_name)
withRowNum -
SQL and PLSQL
What is the difference between SQL & PLSQL?
Nazeera Jaffar
- Sep 26th, 2012
1.Sql is a declarative language.It tells only what to do. PL/Sql is a procedural language.It tells what to do and how to do. 2.Sql executes DDL and DML statements . Pl/Sql executes triggers,func...
sampra
- Mar 6th, 2012
sql is structured query language and plsql is procedural sql. in sql we write a query to fetch the data from data base. in pl sql we write the set of sql command and execute it in one times. the benef...
Insert a record in two tables
How to insert a record in two tables with single insert statement ?
Nazeera Jaffar
- Sep 30th, 2012
Answer:
CodeThere is a % sign in one field of a column. What will be the query to find it?
'' Should be used before '%'.
Left Outer & Right Outer Join
What is the use of Left Outer & Right Outer Join, Using Equi Join with Union we can do the outer join then why we need to go for Outer Join
aytasirs
- Nov 15th, 2012
Left outer Join fetch all the records from Left side Table(Only Condition satisfied records from right side table) where as Right Outer Join fetch all the records from Right side Table(Only Condition satisfied records from Left side table).
sampra
- Mar 6th, 2012
Using Equi Join with Union we can do the outer join then why we need to go for Outer Join -- increase the performance
How to avoid duplication in database if we are adding data from .dat file ?
aytasirs
- Nov 15th, 2012
There is no option to avoid duplicates when inserting data from flatfiles using sql*loader.
The best way is load the data into staging table and write the
query to eliminate the duplicate rows.How do you know which index a table is using?
I have two tables EMP1&EMP2 both having same fields if any updations made in emp1 how to reflect on emp2
What is the difference between NO DATA FOUND and %NOTFOUND ?
What is Query Analyser?
Sundaresan
- Aug 29th, 2006
Grid computing
Select comm from emp;
The Null column in the output will come in the last i.e at the end. WHY?e.g COMM 1200 1000 1300 1450 ---- (NULL) ---- (NULL)
Anurag Puranik
- Jul 29th, 2006
Nulls are unassigned and unavailable values.i.e. null means "no value".So in order to obtain values the values get preference over the no values(null).
Retrieve Rows Without Using SELECT Clause
How can we retrieve some rows from the database without using select clause?
Fetch Alternate Rows
How to fetch alternate rows from the table?
Display the number value in Words?
SQL> select sal, (to_char(to_date(sal,'j'), 'jsp'))from emp;the output like,SAL (TO_CHAR(TO_DATE(SAL,'J'),'JSP'))--------- -----------------------------------------------------800 eight hundred1600 one thousand six hundred1250 one thousand two hundred fiftyIf you want to add some text like, Rs. Three Thousand only.SQL> select sal "Salary ",(' Rs. '|| (to_char(to_date(sal,'j'), 'Jsp'))|| ' only.'))"Sal...
Ans