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?
No Answer is Posted For this Question
Be the First to Post Answer
What are the types of index?
How to display top 10 rows in mysql?
What does mysql flush tables do?
How to drop an existing index in mysql?
How many concurrent queries can mysql handle?
What is field in mysql?
How do I kill a mysql query?
When to use order by in delete statement?
What is triggers?
Why do gaps in sequences occur?
What is the diff. bwt. primary key and unique key?
How many entries can mysql handle?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)