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 other commands to know the structure of a table using mysql commands except explain command?
Is it possible to update a table value with out using update command?. if yes what is the reason, if no what is the reason?.
How can we know the number of days between two given dates using MySQL?
2 Answers Base2 Infotech, Webworks,
What is mysqli_connect_error ()?
Where is mysql data stored?
What is the storage engine used for MySQL?
How do I select a table in mysql?
Is pdo faster than mysqli?
How do I zip a file in mysql?
Hi Team, This is kartik, I recently completed my B-tech. Importance of posting this question is for to know the best books on SQL(MYSQL/Oracle)? I like SQL concept's so much, at the same time i decided to choose SQL for my career purpose. So please suggest me the best books that are very helpful for a fresher to improve concepts like (SQL/PLSQL)Basics, programming concepts, architectures etc. Please consider my request as an important one. I am very thankful to you for providing this opportunity. If possible can you please send the names of books for my personal id also: karthikgdv1206@yahoo.com. Thanks, Kartik T
How to shut down the server with 'mysqladmin'?
What is the current root password of mysql?
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)