Display details of employees having same char at the star and end postition of their namelike abishikathis name have last character and first character is same

yuvaevergreen

 Profile Answers by yuvaevergreen Questions by yuvaevergreen

• Jun 8th, 2011

In Teradata,sel * from employee where substr(name,1,1)=substr(name,length(trim(name)),1)

Miao Lin

 Profile Answers by Miao Lin Questions by Miao Lin

• May 9th, 2011

SELECT * from employee where SUBSTR(EmployeeName, 1,1) = SUBSTR(EmployeeName, -1,1);

Answer Question  Select Best Answer

I have a column in a table with names.Now i want to select that names like first name,second and third.I/p like this----- names Chandu Kannaka prasad Rama krishna Kiran kumar Kora Balaji Chandra sekhar pottaO/p I want------ Firstname Secondname Thirdname ...

skcwebworld

 Profile Answers by skcwebworld Questions by skcwebworld

• Aug 7th, 2015

"tsql declare @Name NVarchar(MAX), @FName NVarchar(MAX), @MName NVarchar(MAX), @LName NVarchar(MAX) select @Name = SAURABH KANT CHAKRAVARTI --select @Name = SAURABH KANT s...

farhanbaig

 Profile Answers by farhanbaig Questions by farhanbaig

• Jun 7th, 2011

I am guessing you are looking for initcap function which are as follows:select initcap(first_name||' '||second_name||' '||third_name) from employees;

Answer Question  Select Best Answer

Read Best Answer

Editorial / Best Answer

nirmal1in  

 Profile Answers by nirmal1in Questions by nirmal1in

• Member Since Jan-2010 | Jan 17th, 2010

---

This can be accomplished in following way:

Example: table - emp

For First n rows:

SELECT * FROM
(SELECT empno,ename,job,row_number() over (order by ename desc) a
FROM emp) x
WHERE x.a < 5 --- say n is 5 display first 5 records

For last n rows:

SELECT * FROM
(SELECT empno,ename,job,row_number() over (order by ename) a
FROM emp) x
WHERE x.a < 5

FROM )WHERE .a<

This query can be used for finding nth row also say n = 5

SELECT * FROM
(SELECT empno,ename,job,row_number() over (order by ename desc) a
FROM emp) x
WHERE x.a = 5

deepthi

• May 17th, 2012

Code
SELECT rownum,a.*FROM(SELECT rownum,b.*FROM emp b ORDER BY rownum DESC) a WHERE rownum <&n;

Vasavi Katakam

 Profile Answers by Vasavi Katakam Questions by Vasavi Katakam

• Jul 18th, 2011

For First N Rows:

Code

1.  
2. SELECT top 5 * FROM table_name
3.  

For Last N Rows:

Code

1.  
2. SELECT * FROM
3. (SELECT top 5 * FROM
4. table_name
5. ORDER BY Columnname DESC)
6. ORDER BY Columnname ASC
7.  

Improve Answer

What is water mark apporach in SQL?

godsrikanth

 Profile Answers by godsrikanth Questions by godsrikanth

• Dec 3rd, 2009

A High Water Mark is when a database (or database table) has reached its maximum capacity, for example, the EMPLOYEE table including current and past employees, could have 1000 rows. That would be its...

Answer Question  Select Best Answer

godsrikanth

 Profile Answers by godsrikanth Questions by godsrikanth

• Dec 3rd, 2009

Difference is in performance.  API is a package call which will process faster since its already compiled.  It can be called globally.  Stored PL/SQL call is not compiled into memory and may take more time.

Answer Question  Select Best Answer