Suppose you have to collect the first name, middle name and the last name of students from the below table. But, you observe that there few missing values either in the first name, middle name and the last name columns. How will you return the first non-null values?
- 0 Answers
- 462 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
What do we use to remove duplicate records while fetching a data in mysql ?
Is foreign key indexed mysql?
what is the difference between MyIsam and InnoDb engine?
What are the advantages and disadvantages of using mysql?
How to convert character strings to dates?
Explain GRANT command in MySQL.
What is “i_am_a_dump” flag in mysql?
What are the advantages of MySQL when compared with Oracle?
What is difference between unix timestamp and mysql timestamp?
about foregine
In the below example, how many String Objects are created? String s1="I am Java Expert"; String s2="I am C Expert"; String s3="I am Java Expert";
Can we join 3 tables in mysql?
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
