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
- 709 Views
- I also Faced
- E-Mail Answers
Does adding an index lock a table?
What is a definer?
What is sql in mysql?
What is 'mysqldump'?
How do I start mysql client?
What is row level locking?
How do I backup mysql database on linux?
How would you backup and restore a big MySQL database? What are the advantages of the approach which you have taken over the others?
Can you tell the difference between $message and $$message?
What are the reasons for selecting lamp (linux, apache, mysql, php) instead of combination of other software programs, servers and operating systems?
How to execute mysql query in php?
How much does mysql cost?
-
Oracle (3258) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3328)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
