How can I get only the First Name of all the Customers from the Table using a Single Query?

By: Jyoti Pandey | 12 May 2015 3:13 pm | 0 Comments

Hello Experts,

There are few records in a table.

One of the column is FIRSTNAME_MIDDLENAME_LASTNAME.

Means it contains FirstName MiddleName(Those who have) and LastName for all the records.

EX:- Samir_Kumar_Roy
Rakesh_Ranjan_Dash
Vishal_Sharma
Ragini_Jain
Raj_Shekhar_Reddy
and so on.

And my query is that how can I get only the FirstName of all the customers from the table using a single query?

Please assist here.

Thanks in advance.

Comments

No Comments Posted for this Article.

Query About Single Table-space.
Hello Experts A single tablespace supports maximum of 65,536 datafiles. If i created 10 tablespaces then 10X65,536. Is it right. Another thing is upt to how much size of datafile is...
How to Search for +*-/ in String Using Oracle SQL Query
Hi All, i have a query select REGEXP_INSTR ('3.8+3.2', '[*+-/]') from dual; out put is 2. why because it is searching the dot(.) first but i want to it should return 3 because i...
Single Signon
What is the difference between authentication and Single Sign-On? In computer security, authentication is the process by which a computer, computer program, or another user attempts to confirm...
Dynamic Table Names and Moving Table
I'm fairly new to PL/SQL and I could use some help. I'm trying to create a cursor and build the tablename based on an input parameter. Currently I'm using DBMS.SQL statements, which I find cumbersome...

Forums

Books

Jobs

Opening for Sr. SAP Basis Consultant @ Bangalore (Immediate
Exp :6 - 15 years | City : Bangalore
SAP Hana Cloud Integeration | 6 - 9 Years | Pune | Atos
Exp :6 - 9 years | City : Pune
SAP with Portuguese & English Langauge Support | 3 - 6 Years
Exp :3 - 6 years | City : Hyderabad
Solution Architect for the Oracle Hyperion EPM Suite | 8 - 1
Exp :8 - 13 years | City : Bangalore
Sr. SAP ABAP FI Developer | 8 - 13 yrs | Hyderabad / Secunde
Exp :8 - 13 years | City : Hyderabad

ASK US !

Get solutions from our experts!

A&D (Aerospace & Defense)
ABAP
About SAP
Android
Announcement of Legal Change
APO (Advanced Planner and Optimizer)
Audit Management
BASIS
BCM (Business Communication Management)
BI (Business Intelligence)
BI Suite - Business Explorer
BO (Business Objects)
BODS (Business Objects Data Services)
BOPF (Business Object Processing Framework)
BPC (Business Planning and Consolidation)
BPM (Business Process Management)
Business ByDesign
Business One
Business Suite
BW (Business Warehousing)
C++
CLM (Contract Lifecycle Management)
Cloud
CRM (Customer Relationship Management)
CS (Customer Service)
Do It Yourself
DSiM (Demand Signal Management)
E-Recruitment
EAM (Enterprise Asset Management)
EC (Enterprise Controlling)
EHS ( Environment, Health, and Safety Management )
EP (Enterprise Portal)
ERP (Enterprise Resource Planning)
Event Management
EWM (Extended Warehouse Management)
FICO (Financial Accounting and Controlling)
FIN-FSCM (Financial Supply Chain Management)
Fiori
FS-BA (Bank Analyzer)
FS-CD (Collections and Disbursements)
Governance
GST (Goods And Service Tax)
GTS (Global Trade Services)
GUI (Graphical User Interface)
GWM (Gateway for Microsoft)
HANA
HCM (HCM Human Capital Management)
HR (Human Resource)
Hybris (SAP E-Commerce Software)
IdM (Identity Management)
IFRS (International Financial Reporting Standards)
IM (Investment Management)
Integration Server
IS (Industry Solutions)
IT Management
Java
KW (Knowledge Warehouse)
Landscape Transformation of Replication Server
Logistics Information System
Lumira
MaxDB
MDM (Master Data Management)
ME (Manufacturing Execution)
MM (Materials Management)
Mobile
MRS (Multi Resource Scheduling)
MySAP
MySQL
NetWeaver
OCM (Order Change Management)
OM (Organisational Management)
Oracle
Oracle SQL
PE (Product Enhancement)
Photoshop
PHP
PI (Process Integration)
PLM (Product Lifecycle Management)
PM (Plant Maintenance)
PO (Process Orchestration)
Point-of-Sale (POS) Data Management (DM)
Postalsoft
PP (Production Planning)
PPM (Portfolio and Project Management)
Predictive Analytics
Project Manager
PS (Project Systems)
Python
QA (Quality Assurance)
QM (Quality Management)
SAP Office
SCM (Supply Chain Management)
SD (Sales and Distribution)
SEM (Strategic Enterprise Management Software)
SEO (Search Engine Optimization)
Shared Service Framework
SOD (Segregation of Duties)
Solution Manager
SQL
SRM (Supplier Relationship Management)
SSO (Single Sign-On)
TAO (Test Acceleration and Optimization)
TDMS (Test Data Migration Server )
Telecommunications
Third Party
TM (Travel Management)
TR (Treasury)
UI5
UNIX
User Experience (UX)
Warranty Management
WEB DYNPRO
Web IDE
Windows
WMS (Warehouse Management System)
XI (Exchange Infrastructure)